I have 7 tables: pub, writer, editor, client, articles, pub group, adreps. Each has an autonumber primary key. Of the 42 relationships between them, 12 are one to may, but 30 are many to many.
I want to query all combinations of clients, pub, writer, editor, and article. Also, all combinations of pub, pub group, and adreps.
Do I need a junction table for each many to many, or can I combine them? My understanding is that generally junction tables contain the primary key from 2 tables. What is the best way to define the relationships between these tables?
Thanks in advance.
Eric
I want to query all combinations of clients, pub, writer, editor, and article. Also, all combinations of pub, pub group, and adreps.
Do I need a junction table for each many to many, or can I combine them? My understanding is that generally junction tables contain the primary key from 2 tables. What is the best way to define the relationships between these tables?
Thanks in advance.
Eric