View SQL Server Table Hierarchy in ms access

Question

I am working on replacing an old ms access system with an SQL server one with a C# front end. Unfortunately I have some die hard ms access users who will be accessing the SQL server tables from ms access but to them it should essentially look the same.

When tables are created in ms access and a relationship is created between them they show in a hierarchical view with a + sign to get to the lower table in the hierarchy.

Is there a way to replicate this when using linked SQL Server tables? I have tried replicating the relationships in SQL server with ones in ms access but it had no effect.

Answer 1

I don't know if cascading datasheets work or not with SQL Server tables/views. But I do know that you can create a datasheet form and embed a datasheet subform and when you display it as a datasheet, you get the plus signs, i.e., the cascading datasheet structure. It's not as flexible out of the box as non-form cascading datasheets, but if you wanted to, you could build the functionality to swap datasheet subforms the same way you can swap different related tables.

Ask if you need more detail.