Validation per layout

[LarryLogic]

From only one layout, I want to force a field to be used IF another field is used. I have tried using "If" and "STATUS(CurrentLayoutName)" in the field validation by calculation. I can't find the right combination.

Just a reminder message would work.

Larry

[ernst]

Hi Larry,

Try:

Case((Status(CurrentLayoutName) = "YourLayout") and not IsEmpty(AnotherField) and IsEmpty(TheField); 0 ; 1)

Regards,

Ernst.

[LarryLogic]

Ernst,

My fields are STARTAMOUNT and CUSTOMER. If STARTAMOUNT is used I need to force a customer. I also have the opposite on a different layout. Would I use your code in the Calc validation for the field? How would I place the field names.

Thank you for the help.

Larry

[ernst]

Hi Larry,

Code goes indeed in the Calc validation for the CUSTOMER field:

Case((Status(CurrentLayoutName) = "YourLayout") and not IsEmpty(STARTAMOUNT) and IsEmpty(CUSTOMER); 0 ; 1)

Regards,

Ernst.

[LarryLogic]

OK, now it gives me a "THIS FIELD CANNOT BE FOUND" error and highlights the ;0;1

I don't know how to relate this to setting the field as "MUST ENTER" or NOT.

Or inputing "not used" would work.

Sorry, I have tried to find examples in help on these calculation and formula codes without any success.

Larry

[kenneth2k1]

Hi:

The euro version uses ( instead of (,).

Judging from the calc, I think the same thing can be achieved using that same syntax without the case statement. But whatever works.