But if the case is different like
Table A Table B
Invoice Number Inventory Number Inventory Number
101 100001 100001
101 100002 100002
102 100001 100003
102 100002
Note: Inventory Number in Table A is inserting from Table B by using a script.
Now, I want to prevent the duplicate entry that in Table A, if invoice number 101 has the inventory number 100002 don't get an insert it from Table B.
I think unique value validation will not work in this case. Looking for the suggestions.
Thanks
A text field with this auto-enter calculation (clear the “do not replace” check box):
invoiceNumber & “|” & inventoryNumber
could have the unique values validation applied to it.
Bettwr, however, to keep the user from being able to select the same item twice in the first place. A dwindling value list or certain selection portals might be used to prevent the selection of duplicates.