duplicate values

B

Bisha

I have a subform inside the main form .
On the subfrom I eneter some statistics like :

ProductID Quantity Date

On the main form I have, receipt number and some other data that are linked
with data on the subform .
When I eneter data on the subform the ProductID should be unique for each
receipt .
If I enter the same productID the program should warn me .How can I do that
?
 
Top