I have 2 tables (obviously).
Contractors and contractorsub.
This is going to be a 1(contractors) to many(contractorsub).
I have a PK on the id in contractors. For contractorsub, I have 3 fields in it and to get a unique value per record I need all 3 fields. So, should I make a composite PK or just index the 3 fields? I am using SQL Server 2K
Matt