Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training - Referential integrity
|
|
|
The UK's most regular 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. |
microsoft access training - Referential integrity
Resolved · Low Priority · Version Standard
Reply Wed 11 Jul 2007, 09:24Delegate Nigel said...
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.
For upcoming training course dates see: Pricing & availability
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.
|
|