Setting Table Relationships in Access 2016

Start 30-day free trial of MS Access 2016 on Apponfly, log in to it. To build a table relationship in Access 2016, you must first open the Relationships window. You do that by following these steps:

  1. Click the Database Tools tab on the Ribbon
  2. From the Relationships group, click the Relationships button.
  3. For each pair of tables you want in the relationship, click the table and then click Add.
  4. After you finish adding tables, click the Close button.
  5. Put the mouse pointer on the field you want to relate in the parent table (the "one" table in the one-to-many relationship) and hold down the left mouse button.
  6. While holding down the left mouse button, drag the mouse pointer from the parent field to the child field in the child table (the "many" table in the one-to-many relationship).
  7. Point to the related field in the child table and release the mouse button.
  8. In the Edit Relationships dialog box, select the Enforce Referential Integrity and Cascade
  9. Delete Related Records options.
  10. Click Create to set the relationship.

Leave a Reply