Conditional Data Validation
I have a table where we enter all our parts and service item numbers to have them automatically populate our maintenance summary reports. My colleague is asking if I could have data validation to make sure she doesn't enter information twice. The issue is that often two vendors will have the same part number so I'm looking at putting in a "conditional" data validation and can't seem to make it work.
Is it possible to have the "unique value" check box checked but have a condition that it only kicks in when the Vendor ID Match Field is the same as another record in the same table? Otherwise allowing duplicates when the part number is the same as another record but has a different vendor assigned to it.