I am working with FileMaker 5.5. I have to fields, field-1 and field-2

What I want is:

if field-1 contains the word "Leak" then field-2 must be filled in with "Yes, No or Not Required" which is selected from a popup menu.

if field-1 is empty then field-2 should be empty

can someone please help with a suggestion

Try this on for size, it seems to work well in FMP 5.0:

This is Validation by Calculation for Field 2:

If (not IsEmpty (Field 1), PatternCount (Field 1, "Leak") = PatternCount (ValueListItems (Status (CurrentFileName), "vl_Yes_No_Not_Required") & "

Peter below are my results

It is not working correctly. If field-1 is empty field-2 must also be empty (this part works).

But if field-1 contains the word "Leak" field-2 DOES require data, but not what's in my Value List which is "Yes, No, Not Required"

The name of the Value List is "Leaks Required"

Script I Used:

If( not IsEmpty(Reg Scope Of Work {leak}), PatternCount(Reg Scope Of Work {leak}, "Leak") = PatternCount (ValueListItems (Status(CurrentFileName), "vl_Yes_No_Not_Required") & "

Change the "vl_Yes_No_Not_Required" to the name of your value list (including the quotation marks). Let me know if this works.

The final script

If( not IsEmpty(Reg Scope Of Work {leaks}), PatternCount(Reg Scope Of Work

{leaks}, "Leaks") = PatternCount(ValueListItems(Status(CurrentFileName),

"Leaks Required") & "

This works great

Thanks a lot, I got in a little over my head on this project.

Glad to hear it. It's nice to have one's validations, er, validated.