SSN is not a good choice for a PK. There is no guarantee that it will be unique.
>How do I set two primary keys in a table. In access it was easy. The 2 fields are SSNumber abd PeriodEnd.
>
>I do not want duplicates on both these fields.
>
>Are they both canidate fields. I tried primary of SS and canidate on PeriodEnd, but uniquesness is not there.
>
>Thanks
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer