how do I create relationships in a linked table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How does Access form relationships with linked tables to make sure
information in a one-to-one relationship isn't corrupted?
 
Relationships must be created in the database that contains the source
tables, not the database that contains the links. Access does allow you to
create relationships between linked tables, but you can not enforce
referential integrity on these relationships (which makes them pointless in
my opinion).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

linking tables and relationships 3
Disappeared Relationships; Can't Recreate 2
Linked SQL Tables don't report Cascading Updates and Deletes 2
Problems with query relationships in linked foxpro database tables 3
So many relationships 16
Object dependencies vs. relationships 4
Where should relationships be created? 4
Relationship Help with Tables 1

Back
Top