Yes, I could see the relationships in that view.
I've found my own solution: create a query on the first linked table, just pulling * and then when I open that query it will then allow me to insert -> subdata sheet and choose a linked table. When I was previously opening the linked table insert -> subdatasheet was greyed out and not available.
If you open the query in design view and try to change the subdatasheet...
ivrguru
Last Activity: Nov 1 '06, 07:09 PM
Joined: Oct 10 '06
Location:
-
subdatasheets with linked tables broken? Access 2003
All,
Since upgrading to Access 2003 from 2002, I've noticed that all of the linked table subdatasheets I had set up in 2002 with simple relationships are now not working in 2003. Since the majority of what I do with Access is simple inserts and edits, having to bounce around multiple tables and "find" the rows based on the previous table's PK in a list of thousands, makes 2003 completely unusable. Any suggestions on how to... -
bump, if anyone could shed some light i would sincerely appreciate it!Leave a comment:
-
Access 2002 vs Access 2003
I have a small access database that consists of linked tables to/on an Oracle server. Relationships are configured in 2002 to allow a secondary table to display records where a one to many join exists. In 2002, I can see each of the primary table rows has an expandable subdatasheet. Nothing I can do in 2003 will show this same expandable subdatasheet view of the associated records in the secondary table.
I'm -><- this close to...
No activity results to display
Leave a comment: