many-to-many relationship

B

Bob

When confronted with a many-to-many relationship between tables what will
Access produce if the two tables are joined?
 
D

Douglas J. Steele

Access won't do anything: you have to.

To resolve a many-to-many relationship between two tables, you need to
introduce a third "intersection entity" that contains at least foreign keys
pointing to the primary keys of the two other tables.

For instance, if you've got a many-to-many between Products and Invoices
(one product can appear on many invoices, and an invoice can contain many
products), the Products table has as its Primary Key a field named ProductId
and the Invoices table has as its Primary Key a field named InvoiceId, you'd
introduce a new table "InvoiceDetails", which would have at least ProductId
and InvoiceId as fields in it.
 
W

WendyWest

You will get everything from both tables where the fields you are linking on
match.
 
Top