I 2 of 5 check duplicates

[Databaseguy]

We're implementing an 1 2 of 5 system where I work. Basically, an I 2 of 5 is a unique number given to an assorment of product. For instance:

I 2 of 5 number 1 could consist of

1 ea product 1
2 ea priduct 2
2 ea product 3
1 ea product 4

When adding a new I 2 of 5, I want to make sure that the above listed combination of products and quantities does not already exsist in the DB. If it does I'll diplay a message saying that combo (assorment) already exsists for I 2 of 5 "X"

I thought of multiplying the product times the quantity, and summing the result, but different product combos and quantities could have the same sum.

I usually don't cross post but I'll put this in the MS Access area too.

 

[Nevermoor]

instead of product times the quantity, product * 1000 plus the quantity should do it (make 1000 as big as it needs to be so that you can ensure there is no quantity value >= it)