We help IT Professionals succeed at work.

How to define combination of fields as a non duplicate combination.

Fritz Paul
Fritz Paul asked
on
101 Views
Last Modified: 2017-03-21
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.
SShot of table design
Comment
Watch Question

Remote Training and Programming
CERTIFIED EXPERT
Top Expert 2015
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
Thanks. That was so quick and sooo helpful
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
CERTIFIED EXPERT
Top Expert 2015

Commented:
you're welcome ~ happy to help