Calculation, Validation or Script

[Rotorian]

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.

[transpower]

Validated by calculation:

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

[Lee Smith]

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

click here

HTH

Lee

[Rotorian]

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.

[Rotorian]

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?

[Rotorian]

AGH!

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

[-Queue-]

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

[transpower]

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

[Rotorian]

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".

[-Queue-]

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.