Problem with Validation expression

[gaby78]

I have 2 fields: Vendor and TicketNbr

The rule is: if Vendor is “PBS” the user must enter a TicketNbr, If vendor is not “PBS” a TicketNbr is optional.

I tried Case (Vendor = “PBS”; Not IsEmpty(TicketNbr)) but it keeps requiring a TicketNbr regardless of what is entered in Vendor. I tried various combinations with Case( ) and If ( ) etc…but nothing worked.

[mr_vodka]

Try Case (Vendor = “PBS”; 0; 1 )

[David Jondreau]

Case (Vendor = “PBS” and isEmpty(TicketNbr); 0; 1 )

[gaby78]

Hello Mr. Vodka and David:

Thanks for trying to help. I tried both expressions but didn't work. It does not validate; If you enter PBS as Vendor it allows you to move on without entering anything in TicketNbr.

[David Jondreau]

Put that calc in the Vendor validation.

[gaby78]

It works perfectly. Thanks David