RE: access
Hi Jack
Thank you for your question
If you wish to relate two tables, open the relationships window using the relationships button on the main toolbar of the database window.
Show the tables that you wish to relate and then click and drag on the primary key field in the parent table and drag over the foreign key field in the child table
Regards
Stephen