Question

how to create a relationship between 2 tables in ms Access ​

Answer 1

Explanation:

Drag the field that you want to relate from one table to the related field in the other table.To drag multiple fields,press Ctrl,click each field,and then drag them.

In most cases ,you drag the primary key field one table to a similar field that is called the foriegn key in the order table.