I would not reccomend using a concatenated primary key if you plan on using referential integrity. VFP's RI implementation does not work properly when using concatenated primary keys.
>I have a table in which no single field uniquely identifies a record. It seems that to identify each record uniquely I need to concatenate several fields together to form a unique key. Is it best to use this concatenated key as the primary index or should I add another field to each record and put an abstract unique value in it and then use that as the primary index?
kenweber
GCom2 Solutions
Microsoft Certified Professional