• Unique model for each make (2000 SR-1 )

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Unique model for each make (2000 SR-1 )

    Author
    Topic
    #393425

    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

    Viewing 0 reply threads
    Author
    Replies
    • #713166

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

    Viewing 0 reply threads
    Reply To: Unique model for each make (2000 SR-1 )

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: