How to I create a generic validation for multiple number of zoom fields that when the value is not on the reference table of the zoom selection it will display an error message

http://www.baanboard.com/baanboard/attachment.php?attachmentid=5555&stc=1&d=1373478364

Hi,

You can use check.input in the field section or when.field.changes.

e.g.

field.fieldname:

check.input:


| Select loop to check if the field is present in the reference table or not
select tablename.*
from tablename
where condition
selectdo
selectempty
message("Error Message!!") | Error message if not found
input.again()
endselect