No Duplicates Allowed! (FileMaker 5 & 5.5)
I have a table with a list of items, each of which has a unique product number that is a calculation (=Product Number + "-" + Customer Number). I'd like for a message to pop up if someone tries to enter a duplicate unique product number. However, I don't have any validation options when using a calculation field. Any ideas?