Unique invoice number by vendor
I have a field called VendorInvoice and a VendorID field.
I'd like to perform a check the ensures we do not accidently enter the same invoice twice and all my scripts aren't quite cutting it. Figured it's probably simpler to just have someone oh here quickly show me the trick. Ideally I'd like to have it be a script trigger OnObjectExit, thoughts??