Re: How to check if a value is in a table column.

If you create the field Related Zip Code in the Orders table first as a formula field, then relate the tables together you can then create a Triage Field to check if the Parent Zip Code actually exists.

Here is a formula check box in the Orders table

if ( [Formula Number]=1, True, False)

You now have a check box that will tell you if the Orders Record has a Parent in the Zip Codes Table.

Use that for your reports and status such as Triaged.