unique constraints

[rrhandle]

Is there a way in Access 2000 to create a unique constraint or primary key composed of multiple fields?

 

[tlbroadbent]

In the design view, you can select the columns that should compose the Primary Key and hit the Primary Key button on the main toolbar or Select Edit | Primary Key.

If you want to create a multiple column index you can create a query like the following.

Create Unique Index IxEmpName
On Employees (LastName, FirstName, MidName)

This will create a Unique index on the table composed of three columns. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.