98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training - Referential integrity
microsoft access training - Referential integrity
Resolved · Low Priority · Version Standard
Nigel has attended:
Access Intermediate course
Access Advanced course
Referential integrity
Where you have two existing tables both already populated with data, if you then select referential integrity between a foreign and primary key on each table, will Access validate the two table ensuring that referential integrity exists?
i.e. would tou receive an error message if there is a record on one table which breaches the referential integrity rule you are trying to create.
RE: Referential integrity
The answer is yes, Access should validate the relationship.
A suggestion is to make a copy of your database, and then test this to see exactly what your result will be.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |