Establishing relationships and maintaining referential integrity

Once our data tables have primary and foreign keys established, we need to let…Access know which fields relate to which.…We can do this with the Relationships tool, you can find it in a couple…of places, usually you are going to go to the Database tools tab and find…Relationships here.…If you have a Table open, I am going to go ahead and double-click on…this Customers table.…You'll also find under the Tables tools Conceptual tab and Relationships here.…However, in order to modify or create Relationships between Tables;…those Tables need to be closed.…

So even though you can get to Relationships through the Tables tab, it'll often…create a situation where you can't edit it once you get there, because the…original table is still open.…So let's make sure our Tables are all closed by clicking the Close button over…on the right side, and then going to Database tools>Relationships.…The Relationship screen is essentially a blank canvas where we can layout a map…of all of our tables and how they relate to one another.…