Validation againts other table in fc

[sigtb02]

Validation againts other table in format control



In the Queries tab set Add & Upd to true



Set Req'd to the conditional expression ex. not null(assignee.name in $file).



Filename is a must this should contain the name of the other table ex. operator.



Be sure not to add the Field Name to Check.



Query should be structure in the following way. [field name of other table]=[field form present table] in $file ex. name=assignee.name in $file.