MDM Validation help

[Former Member]

Hi All,

I need to build a validation logic that works this way:

If FieldX has value A then FieldY should have value either 1,2 or 3 (Not Blank or any other value) given that FieldX and FieldY both are lookup fields with legal value set.

I was able to build a validation around this but the problem I face is when FieldX has any other value than A then FieldY need not be restricted to 1,2 or 3.The validation fails here when it should not

So it is not working fully

Can you help me build the correct validation.

Thanks a lot

AJ

[Former Member · Accepted solution]

Hello AJ

You can create 2 different validators

One for

"If FieldX has value A then FieldY should have value either 1,2 or 3 (Not Blank or any other value) given that FieldX and FieldY both are lookup fields with legal value set."

Another for case when "FieldX hasn't value A"

Regards

Kanstantsin

[Former Member · Accepted solution]

Hi Kanstantsin,

Can you help me with the expression.

Thanks

AJ

[Former Member · Accepted solution]

Hello AJ

First Validator expression sould be:

Field X="A" AND (Field Y=1 OR Field Y=2 OR Field Y=3)

where "Field X", "Field Y" - field's name

For second validator should be:

Field X<>"A"

Only copy that expressions and Past it to your validator expressions

Regards

Kanstantsin

[Former Member]

Hi ,

You can try this one

IF(Field X=A,Field Y=1 OR Field Y=2 OR Field Y=3,Field Y)

Regards

Nisha

Edited by: Nisha L on Dec 14, 2009 10:05 AM