3 Replies Latest reply on Apr 16, 2010 11:23 AM by philmodjunk

    Using a combination of 2 fields in a table to validate Data entry

    jms_1

      Title

      Using a combination of 2 fields in a table to validate Data entry

      Post

      Hi there,

       

      I am VERY new to this and a novice to filemaker.

       

      I have a table RECIPE_MAIN and in it are 2 yes/no fields

      1: Can this recipe be used as a Dish? RECMAIN_UseAsDish

      2: Can this recipe be used as an ingredient in a dish? RECMAIN_UseAsIngredient

       

      So the possible Combinations of these 2 are

       

      Yes and Yes - Identifying the recipe as both a stand alone dish and a possible ingerdient in a more complex dish

      No and Yes - Identifying the recipe as an ingredient that cannot stand alone as a dish

       

      These are fine, but for the following 2 I want the record to be disallowed

       

      Yes and No - If the recipe cannot be used as an ingredient - ie is a dish and only a dish, it should be recorded in the Dishes table

      No and No - if the recipe is not a building block for a dish, and is not a dish..... it is invalid - ie, this is a mistake, 2 No's were selected by mistake

       

      Any ideas

      Thanks

       

      FMpro 8 in Snow leopard