linking tables question

[Guest]

After reviewing Access Help on how to link a table from another Access file,
I am unsure of how to proceed. Do I have to create a replica table of the
one I want to link to?...or do I just pull the desired table in on its own?

Then...do I have to set up relationships?

Thanks you!

 

[Guest]

Hi Kevin

If you want to link a table from another access, it is very simple actually.
Open the access database where you want the table to link to. Then go to
'File', and then go to 'Link Tables'. Once you select this, it open a browse
window where you should be able to select the access database file where the
table that you want to link reside. Once you do that, it will ask you which
table, just select the appropriate table.

The link table then should appear on your Tables list. It is pretty cool
feature actually. From there you can query the link table.

Lucas