Skip to Content
0
Former Member
Aug 05, 2014 at 03:03 PM

Validation of 2 fields in the same table line

16 Views

Dear all,

I'm trying to create a simple validation.

Check

ANLC-AFABE = '05' AND ANLC-ANSWL = '0.00'

The check should be:

if the valuation area is = 05 and IT'S asset value transaction is different than ZERO, then an error should occur.

however the error message is raised either if there is zero or other values in the ANLC-ANSWL (asset value transaction) field.

Maybe the program is not considering that in ANLC table, the check should occur for both fields in same line (val. area 05 & ANSWL = 0,00)

can you please guide on the validation?

thank you