Fritz Paul
asked on
How to define combination of fields as a non duplicate combination.
I have a table with some fields. Two of them are Nr (string) and Anno (integer). Each of these two may exist as duplicates, but the combination of any two may only exist once. Is there a way to define the table to ensure that?
(The reason is that Nr refers to a customer and Anno refers to a year and each customer may only occur once each year.)
Thanks.
(The reason is that Nr refers to a customer and Anno refers to a year and each customer may only occur once each year.)
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you're welcome ~ happy to help
ASKER