Relationships

1. Click Relationships to ensure that the relationships are set up correctly.

2. You can see all the four tables on the design view.

3. If you do not see any lines connecting the tables, you can add the relationships by highlighting the primary key in the main table and dragging it on top of the foreign key in the other table. For example, highlight job_code in the tb:job table and drag it on the top of job_code in the tb:employee table

Here is a screenshot of Relationships:

Note: For a one-to-one relationship, always enforce referential integrity by checking the Enforce Referential integrity box when you right click on the relationship, and edit the relationship.