Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Windy Wellington, Wellington
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unique model for each make (2000 SR-1 )

    This is an inventory database question so it's probably a FAQ.

    I have a table with Make & Model fields. I want to be able to ensure that for a particular Make there are no
    duplicate Models but to allow for different Makes to have identical Models. IOW you can't have two "Ford LeMans" but
    you could have a "Ford LeMans" and a "BMW LeMans".

    How do you go about it? Is that what the "Validation Rule" is for? (For other reasons I don't want to parent:child (normalise) the
    data).

    TIA
    Keith Rodgers
    <img src=/S/flags/NewZealand.gif border=0 alt=NewZealand width=30 height=18>

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Unique model for each make (2000 SR-1 )

    Create a multiple field index on the two fields and set the unique property of the index, rather than the individual fields, to true.
    Attached Images Attached Images
    Charlotte

Posting Permissions

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