Hello,

New to this place, and fairly new to FMP, so pardon the question. This question seems simple enough, but I cant figure it out.

I have two fields, one named "Results" the other is named "Comments". If Results = F then Comments cannot be empty.

Right now i have setup to where if Results = F then the user is sent into "Comments" but I dont want them to get out of the record without actually entering comments. So:

If (Results = "F".........I dont know how to do the Then part.

Thank you for your time, interest and help.

Validated by calculation:

If (resultsf <> "" ; not IsEmpty ( commentsf ); IsEmpty ( commentsf ) )

Take a look at this thread "How to validate data entry in second field?", it appears to answer your question.

click here

HTH

Lee

Thxs Mr. Smith,

Looks like Ray's suggestion is the ticket. One quick question, I am looking for specific data in field 1 and then force the user to enter data in field 2. Field one will always have an entry as it is setup as radial button choice of P or F (for pass/fail). Only when F is present(selected) do i then need an entry in field 2.

Okay,

I came up with this in field 2 validation:

Results = "F" not IsEmpty(Comments)

However, now even when a comment is entered it still doesnt see the entry into the field and asks to enter comment. Suggestions?

AGH!

Nevermind, no matter what value is entered in field1 (with my example), it still asks for a comment.

Results <> "F" or not IsEmpty(Comments)

That's shorter than mine; a Boolean instead of an If statement.

That last sugestion didnt work either, so I took the easy way out. Field cannot be empty and requires a comment even if it is just "None".

Well, it should work. If you zipped and attached your file, we could see what else is going on that may be preventing it from working correctly.