Define an extra text field with an auto-entered calculation:
RECMAIN_UseAsDish & RECMAIN_UseAsIngredient
Set a validation by calculatin on this field:
( Self = "YesYes" ) or ( Self = "NoYes" )
Note: I am assuming here that the two original fields store the actual text "yes" or "no".
Thanks for the reply.
Yes, the fields are formatted for text, and hold either "Yes" or "No"
I see I am on the right track - I had already defined a field RECMAIN_RecipeConfirmation that I wanted to try and make the validation field.
I tried your suggestion, but the expression is not recognised
Filemaker returns "The specified field cannot be found" for ( Self = "YesYes" ) or ( Self = "NoYes" ) - with "Self" highlighted - I presume "self" is not an expression valid in FMPro 8 adv.
I have managed to do the Auto enter Calc - and the field works great - ie enters a combination of the two fields - I just can't seem to validate it!
Thanks a Mil
Sounds like you are using an older version of filemaker. In that case, substitute the name of the field being validated for "self".