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