HH22:
Sounds like an unusual table setup.
Normally you would link in the primary-key field(s) to the foreign key field(s) between the two tables. Then using a query one would pull the related information for use in reports etc.
Table relationships are established in several ways and with several options; however, the most common is via the database tools ribbon/menu and then by the table relationships option in a one to many relationship. (
MS-Tutorial here) Mind you, I very rarely ever use cascade delete... too easy for the user to delete all of one's data by accident... made that mistake once and thankfully I had just backed up the data tables!
The articles located at:
Microsoft Access / VBA Insights Sitemap may prove to be helpful for many of your questions and in particular the article on
Normalization and Table Structures might help you with the design.