validating user data based on imported file

Discussion created by MattW_1 on Oct 29, 2015

I’m trying to figure out the best way to validate a few fields based on an imported file that refreshes every day.


I have a table with “work order” and “part #” that is user entered. I have a file imported (separate table) everyday that also has these two fields. I don’t want the user to be able to add a combination that isn’t in the imported file.


I looked at validating based on a concentrated field with both part/work order number, the issue I can’t seem to figure out when the file imports I can’t seem to get it to concentrate the work/part # in each row at the time it imports.


Is there a better way to do this?