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?