Prevent Duplication records in 2 fields in Table

[perryche]

Experts,
Bascially I want to avoid people entering duplicated records.
However, the check for the duplication are in 2 separate fields. i.e.
Field1 + Field2 can not be duplicated. What's the easiest or best to
do in this case?

I know I can combine the fields in Query, but can I do so in
Tables and check for the dup?

Perry

[Mezzanayne]

Hi Perry,

From the table design, highlight both of the fields and then hit the

Primary Key icon. This will set up the fields to allow for duplicate
entry in either, but not both of the fields (known as a multiple-field
primary key).

HTH,

Megan

[Chuck Grimsby]

For what it's worth, you can also do this without making the two
columns a primary key, by using the index window in the table design
window.

You can also do it via SQL commands if using Access 2000 or above. See
Access' SQL Help on the ADD CONSTRAINT statement.