Discussions

Expand all | Collapse all

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

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

    Posted 01-19-2020 13:24

    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 is from supporting zipcode value then "traiaged" else "not triaged ". how to achieve this through formula ?



    ------------------------------
    Uday Pratap Singh
    ------------------------------


  • 2.  RE: How to check if a value is in a table column.

    Posted 01-20-2020 11:27
    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
    ------------------------------