Hello folks. This is my first question here on this forum I'm a novice, building my first Access DB. My questions concern using Junction tables to build many to many relationships. I will use a simple example to illustrate my questions.
I have two tables:
Product List Table [ProductList] with a PK [ProdID]
Distributor List Table [DistributorList] with a PK [DistID]
Each Product may have more than one Distributor
Each Distributor may have more than one Product
I build a Junction Table [ProdDistribList] with a PK [ProdDistID] to establish a many to many relationship between [ProductList] and [DistributorList]
Questions:
What, if any, are the common naming conventions for creating an FK in a Junction Table?
Can I simply use the identifiers [ProdID] and [DistID] as the FK field names or am I required to create unique names for these relationship fields?
If I have more than one Junction Table with fields relating to [ProdID] or [DistID], does each new Junction Table have to have a unique FK field name to relate to the original PKs?
I hope these questions are clear. Thank You in Advance.
~46