Microsoft Access Relationships 2

[jbieker]

Linked tables from one database to another. then established a relationship. I ran a query and got no matching records. checked the relationship and it was gone.
what could have caused this and what to do to prevent the problem in the future

 

[dhookom]

I don't believe you can enforce relationships with linked tables. You can open the data mdb and set relations between tables included only in that mdb.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[BNPMike]

Whether you have relationships or not shouldn't affect the query. If you are not getting data then there's something wrong with the logic of the query. With relational databases you can join tables using any fields you like as long as they are join compatible (ie compatible in terms of data format). No other link needs to be pre-declared.