A ahvc Registered User. Local time Today, 16:48 Joined Jun 17, 2002 Messages 41 Oct 10, 2002 #1 Hello, Can you please tell me how to create an index or PK for multiple fields in a table. I want three fields together to be unique (to avoid duplication). Thanks VC
Hello, Can you please tell me how to create an index or PK for multiple fields in a table. I want three fields together to be unique (to avoid duplication). Thanks VC
Graham T Registered User. Local time Today, 16:48 Joined Mar 14, 2001 Messages 300 Oct 10, 2002 #2 VC Just select all three fields and click on the Primary Key, which will create your multi-field PK. Graham
VC Just select all three fields and click on the Primary Key, which will create your multi-field PK. Graham