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