How to Create Relationship in MS Access
Creating relationships in Microsoft Access helps connect tables that share related data. Here’s a step-by-step guide to create relationships:
- Open the database file where you want to create relationships between tables.
- Go to the 'Database Tools' tab in the ribbon.
- Click on 'Relationships'.
- Select the tables you want to relate
- Click 'Add Selected Tables'.
- Drag the primary key field from the parent table and drop it onto the corresponding field in the child table.
- The 'Edit Relationships' dialog box appears. Verify the fields being related are correct.
- Select 'Enforce Referential Integrity' to ensure that you cannot enter a value in the child table that doesn't exist in the parent table.
- Click 'Create' to save the relationship.
- Save the relationships by clicking 'Save'.
This website uses cookies to ensure you get the best experience on our website. Learn More
Got it