Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    Colorado Springs, CO
    Posts
    1

    Unanswered: Composite Index question

    I have a table that data is automatically inserted from a VB program. I have one numeric field as the PK - JobNum. Here's my question: is it possible to have 3 other text fields (next to each other) in the table linked together in an effort to make the combination of data in the three fields unique without making them a composite PK? I want to be able to duplicate info in any one of the fields as long as the combined data in those fields never duplicate. Here's an example:

    Field3 Field4 Field5
    uv100 005 0000 Unique combo
    uv100 006 0000 Unique combo
    uv100 006 0001 Unique combo
    uv200 005 0000 Unique combo
    uv100 005 0000 Not allowed - duplicate entry

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Go into your table design and create a new index by clicking on the index button. Add your index name and your 3 field names, then set the
    unique property to "yes"

    That shoudl take care of it.
    Inspiration Through Fermentation

Posting Permissions

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