When you have a relationship set up and you double click on it, there is something there called "Enforce Referential Integrity" when I click on it and say OK and go back in the check is cleared out. What exactly does the Enforce Integrity do?

Also, when setting up a join it specifes a right and left table and column in the join properties. What is the reason for this?

When you set up a query I see that it appears in the navigation under both tables that it effects. Is is possible to only have it appear with one of the tables rather than both?

Thanks for any help.

Bob Snow

>>>I click on it and say OK and go back in the check is cleared out<<<

do you mean that the Referential integrity is not enforced?

>>> What exactly does the Enforce Integrity do?<<<

let's say you had a customer's details stored in the customer table, and you had invoice details stored in the invoice table.

If you accidentally deleted a customer from the customers table who had outstanding invoices in the invoice table then very quickly your database would turn into gibberish.

One of the things Referential integrity does is protect you from this happening.