How to Establish a Relationship Between Tables?
https://www.computersprofessor.com/2016/05/how-to-establish-relationship-between.html
A data base normally consist more than
one table. In order to link from one table to another table, we can create
relationships, i.e., a link between two (Or) more tables with a common key
field in both the tables.
For
example when we create two tables and the first table containing the fields
employee No, Employee name, Department number, and salary. The second table
containing department name and department no therefore you relate both the
table by establishing relationship with the common key field no, department no.
The
following are the steps to establish the relationship between the tables.
1) Click on the tools option and
select relationship.
2) Select table one and click on add
icon so that table -1 goes in a relationship.
3) Now select the table two and again
click on add icon button.
4) Close the table by clicking close
button.
5) In order to provide a relationship
click on department no field in table two.
6) Drag the mouse starting from the
first common field from table 1 to table 2.
7) Then the edit relationship screen
appears. Click on create icon in edit relationship screen.
8) Now close the above screen. After
save the information, the relationship exists between the table.
We
can select the fields in both the tables and easily get the required reporter
query once a relationship is established.