Two Table Relations

Setting relationship between Table -1 and Table-2

1. Click table tools
2. Click relationship
3. Click show table
4. Select table-1 ->add
5. Select table-2 ->add
6. Close Table
7. Drag the C_ID field of Table 1 table and drop on the C_ID field of Table 2 table
8. Referential
9. Click on Enforce relationship/ Referential integrity
10. Click cascade update related fields
11. Click on cascade delete related records
12. Create
13. Click Close
14. Click Yes