How Do You Define A Many-To-Many Relationship In Access 2003?
In Microsoft Access 2003, a many-to-many relationship is an association between two tables in which a record in either table can relate to many records in the other table. To make that relationship, you add a third table and add the primary key fields from the other two tables to this table. Here are some steps on how to define a many-to-many relationship in Access 2003. Close any tables you have open. You will not be able to create or modify relationships between any open tables. Press “F11” to switch to the “Database” window. Click “Relationships” on the toolbar. If you have not yet defined any relationships in your database, the “Show Table” dialog box is automatically displayed. Double-click the names of the tables you want to relate, and then close the “Show Table” dialog box. To create a relationship between a table and itself, add that table twice. Drag the field that you want to relate from one table to the related field in the other table. Check the field names displayed in th
