Relationships with linked tables

[BobJones]

I have a database with a table on a shared network drive. The table contains a list of buildings, building details and a unique building code. I want to be able to use that database as a master copy so any new buildings that need to be added can be.
I have another database with accounts and another database with some other information. I can create a relationship between the accounts and the linked table of buildings (by the unique building code) but if I am to go into the building table, there is no "expansion option" to see all the accounts for that building. Is there a way to create a proper relationship or at least make a copy of the buildings table so that each time the database starts up it can get the latest version?

Thanks in advance,
Bob

 

[neileg]

These features to expand linked data are not very useful. If you build a proper query drawing data from both tables and display this in a form you will get everything you need.

 

[BobJones]

Thanks very much neileg, all done now! Sometimes it helps to just get a fresh perspective on things! Cheers