I have to develop a database on a system where my development options are pretty restricted. I have Access 2007 as my database so decided to use Access Forms for the GUI.
I believe my only other option is a .Net Winform.
This needs to be multi-user so I know I need to separate the GUI from the database.
The problem is, I didn't develop the GUI with linked tables thinking everything is basically 'the same'.
The form I developed includes a datasheet table object. It has a nested table and provides the '+' to expand to add/edit/delete child records.
I've attached a simple parent/child database to demonstrate this if I've used the wrong terminology. If you open the Parent table in datasheet view, you can expand to see the child rows.
Once you create a new database and link to the parent, you can no longer expand.
I didn't realize that I would lose this functionality when I moved to a linked table.
I'm hoping there is a work-around to this without migrating to continuous forms. I would like to keep datasheet so I don't have to rework a lot of the app.