0 Replies Latest reply on Oct 29, 2015 1:17 PM by MattW_1

    validating user data based on imported file

    MattW_1

      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?

       

      Thanks!