Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001

    Unanswered: Unique constraints

    Is there a way in Access 2000 to create multiple primary keys in one table, or unique constraints on multiple columns?

  2. #2
    Join Date
    Oct 2001
    Bay Area, CA
    You can make the field an indexed field and don't allow duplicates. That's the same as a primary key.

    Otherwise when you select multiple fields and make them the primary key, only the combination of the fields forms the unique primary key.

    Hope this helps....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts