Hello guys. I have 2 tables - one is a work order table and the second is an order submit table. I am trying to ensure an operator cannot start a work order thats already been submitted.
I have a put a filter on the first table aka work order table such that it shouldnt show any work order values that already exist in the second table. But it doesnt seem to be working
Any ideas of how to solve this issue?
PS - Work Order ID is the work order name for the first table and Work order is the work order name for the second table