Link to home
Start Free TrialLog in
Avatar of Fritz Paul
Fritz PaulFlag for South Africa

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.
User generated image
ASKER CERTIFIED SOLUTION
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Fritz Paul

ASKER

Thanks. That was so quick and sooo helpful
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

you're welcome ~ happy to help