Compound_key

[somnath_6309]

It may be that there is no unique column in a database. Then it will not be possible to create a Primary key based on a single column.

In that situation a COMPOUND KEY has to be prepared by combining two or more columns.

My question is how this COMPOUND KEY is prepared. Kindly provide me the path or process.



Regards,
Somnath

[qa12dx]

in the table design view, select/highlight all the fields you want to use. if they are not sequential, use ctrl and click. then click primary key.

save the table. if the fields are truely uniquie in the combination, it will save, else it will give you and error.

helps if the tables dont have much data. also, if you want to clean up dups. do a copy paste of the table, structure only. choose and make ur pks. append data into the table. all dups will auto not get appended. rename original table to tbl_xxx_backup. now, rename ur new table to the same

[June7]

Can use an autonumber field as PK. A compound index can be set without making it the PK. The autonumber value will be saved as FK in related tables. http://office.microsoft.com/en-us/ac...010210347.aspx