These instructions are for Access 97. Create another table, called a junction table. In the junction table, add fields with the same definitions as the Primary Key fields from each of the other two tables. Still in the junction table, edit the primary key to include the primary key fields from the other two tables. Add data to the tables using either a query that works with more than one table or by creating a form that works with more than one table.
Foreign keys indicate how the tables are related.
Inc. How things get done. Use of this Web site constitutes acceptance of the eHow Terms of Use and Privacy .