Please Help with Subdatasheets!

[nitinrao]

Hi everyone,



I'm trying to make the subdatasheet for my tables (I've attached a snapshot of the relationships) which shows the following:

- The "Key Users" table with a subdatasheet that shows everything from table "Key Assignments" and fields "Building" and "Room" from table "Key"

- The "Key" table that shows everything from table "Key Assignments" and fields "Last Name" and "First Name" from table "Key Users"


How can I set this up? I've been breaking my back trying to figure this out...
if there are other ways to show this when clicking on the expand button in each table, please offer them (other than using queries).

Please let me know if you'd like to see the database....

[RuralGuy]

Users should not be accessing tables directly and SubDataSheets can negatively impact the performance of a system. http://allenbrowne.com/bug-09.html