Benefits of Referential integrity
Hi Experts,
I am learning to use Access 2007 and have a question on Referential integrity. When I am joining two tables together, access asks for join type. Such as 1:1, then I have the option to use Referential integrity, but what benefits would it bring me? I googled and get more confused, the answer I got is " it won't delete/update the parent information when the child information referred to is modified."
I am learning to use Access 2007 and have a question on Referential integrity. When I am joining two tables together, access asks for join type. Such as 1:1, then I have the option to use Referential integrity, but what benefits would it bring me? I googled and get more confused, the answer I got is " it won't delete/update the parent information when the child information referred to is modified."
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Here are some additional good links on the subject
http://www.fmsinc.com/tpapers/genaccess/databasenorm.html ******** especially this one ***
http://www.databasedev.co.uk/primary_foreign_keys.html
http://support.microsoft.com/?kbid=209534
mx
http://www.fmsinc.com/tpapers/genaccess/databasenorm.html ******** especially this one ***
http://www.databasedev.co.uk/primary_foreign_keys.html
http://support.microsoft.com/?kbid=209534
mx
ASKER
thanks.
Actually, that button should no even be in the Edit Relationships window, because it really has nothing directly to do with the relationship, and only adds confusion to the process. It's doesn't matter what you select (just leave the default).
It only has to do with when ... in the query designer, if you happen to bring in those two tables, Access with automatically (and arbitrarily to me) create a 'join' (in the query) of the type specified in this dialog box (Join Type). I prefer to specify my own join type. I guess they thought this would be a 'convenience' ... but not to me.
mx