When should we use the Database tools to create relationships and when is it not necessary? Up until your courses I was trying to create relationships in the database tools for the one to many on each table.
Sami Shamma
@Reply 2 years ago
Eric
Richard recommends NOT to use the Database Relationship tool in most cases. Define the relationships through the proper design of your tables.
The tool gives you two advantages:
1- It can help you expand the 1-Many record relationship in table views (you should never give access to that view to your end users).
2- It allows you to define Referential integrity. See this video:
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 7.
