I have an imported work order file that imports periodically throughout the day.
The problem I have is when a user is done with a work order they delete it from the database allowing the next import to show that same work order as unique and re-importing it.
I created a separate table/field that copies the workorder number before it’s deleted. I’m trying to have my “work order” field in the import table check the workorder number in the separate table and reject it if it already exists. I thought maybe I could create a validate option “if this work order exists in the other table” don’t validate/delete the work order from the import but I haven’t found an easy way to have that happen.