How to create a multiple column unique constraint

[KemperR]

Dear All,

I want to achieve that the combination of values over multiple columns
in a table are unique.
I know this works for SQL Server, but how do I declare this in an
ACCESS 2000 data base (prefereable in table design ) ?

Any help is welcome

Rolf

[Brian Wilson]

<Ke*****@ee.nec.de> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

Dear All,

I want to achieve that the combination of values over multiple columns
in a table are unique.
I know this works for SQL Server, but how do I declare this in an
ACCESS 2000 data base (prefereable in table design ) ?

Any help is welcome

Rolf

While looking at the design view of the table select View>Indexes from the
menu. Give the new index a name such as MyIndex and add a select a field
(e.g. FirstName) then move your cursor to the cell below and select a second
field (e.g. LastName). Then put your cursor back in the cell containing the
name 'MyIndex' and look at the properties for this index at the bottom left
of this dialog box. Change the Unique proerty to Yes, then close and save
the table.