>>While on the topic, a similar questions. Are people adding a separate Primary key to many to many join tables or using the two Foreign key fields as that purpose?
>
>I've done both. However, a lot of the basic classes I use tend to expect a single field primary key so I normally just add one to keep things consistent, then add a contraint + index on the two other fields.
This seems consistent and what I have always done thus far. I still like it as creating compound keys seems less efficient for my thinking. Thanks for your input.
Timothy Bryan