AnsweredAssumed Answered

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

Question asked by jms_1 on Apr 15, 2010
Latest reply on Apr 16, 2010 by philmodjunk

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

 

Outcomes