Forum Discussion

Uday_PratapSing's avatar
Uday_PratapSing
Qrew Member
5 years ago

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

I have a table called zipcode which contains the list of zipcodes we are currently supporting.  I want to add a record in other table field (say orders), if entered zipcode for this (orders) table i...
Formulas and functions
DonLarson's avatar
DonLarson
Qrew Commander
5 years ago
Uday,

Is the field Zip Code your Key Field?   
Have you related [Orders] to [Zip Codes]?


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.




------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------