andreohnona
New member
- Local time
- Today, 09:50
- Joined
- Feb 10, 2006
- Messages
- 8
Hi,
Two questions regarding choosing & using primary keys:
1) Is it always recommended to use Autonumber as primary key? What about a scenario where the table already has an inherently unique identifier, such as a part number in a product table? What about junction tables?
2) In scenarios where I have a "composite" primary key, such as in junction tables for many-to-many relationships, how do I relate that table to another table?(i.e. to one that it is not already related to as part of the many-to-many)
I am interested in understanding this stuff so all explanations are much appreciated...
thanks!
Andre
Two questions regarding choosing & using primary keys:
1) Is it always recommended to use Autonumber as primary key? What about a scenario where the table already has an inherently unique identifier, such as a part number in a product table? What about junction tables?
2) In scenarios where I have a "composite" primary key, such as in junction tables for many-to-many relationships, how do I relate that table to another table?(i.e. to one that it is not already related to as part of the many-to-many)
I am interested in understanding this stuff so all explanations are much appreciated...
thanks!
Andre