composite unique key

[shital]

hi

Is there any 'composite unique key' concept in access?
if yes how to achieve?

Thanks in advance

[DaveT]

1. For a PrimaryKey, in table design, highlight more than one field, then click on Primary Key icon on table design ribbon.

2. As an alternative, using the indexes dialog in table design, set an index on the first field. then add additional field(s) to the index by typing field name on next line down leaving the index name blank.

Mostly (see indexes properties dialog for some settings such as Primary, Unique, and Ignore nulls) the same rules apply to a compound index as to a single field index: Primary keys cannot be null, etc.