I have a client who wants one field on their data base to be required only if another field is populated with certain information. Is this possible?

I know this syntax is incorrect but, Basically:

If (Field_X = "Condition_A")

Then

Field_Y ; IsRequired)

Else

Field_Y ; Not_Required)

If anyone can help I would greatly appreciate it.

Thanks,

Steve

Hi

try to put this calc into validation option of field Field_Y

Case(

Field_X = "Condition_A" and IsEmpty ( Field_Y ); 0;

1

)

<

try to put this calc into validation option of field Field_Y

Case(

Field_X = "Condition_A" and IsEmpty ( Field_Y ); 0;

1

) >>

Thank you for your reply, however this does not seem to work unless I have doen something wrong...

I have:

Case(CutAway = "c900" and IsEmpty (Solvy); 0;1)

In this case

Cutaway = the "X" Field

Solvy = the "Y" Field

"c900" is the condition that if enterered into the cutaway (X) field then the Solvy "Y" Field becomes required. If the "X "field is empty or has any other information in it, then Y is not required.

I plugged this calculation in to the "Validated by Calculation" area and created a new record. I entereed c900 into the Cutaway field, entered nothing in the solvy filed and was allowed to create a new record. I would have expeceted to get the Validation error message that the "Y" field was required, but did not. :

Have I missed something obvious?

Thanks,

Steve

Edited February 2, 200718 yr by Guest

This is working now....

In the Validation Tab you must:

Select: Always

And in the Calculation Specification:

Deselect: Validate only if field has been modified.

This is a very useful validation routive for me. I hope someone else will have a need for it.

Steve

...In the Validation Tab you must:

Select: Always

And in the Calculation Specification:

Deselect: Validate only if field has been modified.

Only the second is required :