Options

Field Validation

vikasvikas Member Posts: 46
Hi,

I have created a field called "Test" in customer table which is also displayed on the customer card.
Whenever an user accesses the customer card & creates a new record he should mandatorily enter the value in the "Test" field.
To do this i have enabled the "Not Blank" of this field, but it did'nt work.

Please help me in this regard

Thanks & Regards,
Vikas

Comments

  • Options
    2tje2tje Member Posts: 80
    It will not work this way.
    You can check if the field is empty on the table triggers like the OnModify.
    But the best way to do this might be on the Form in the OnNextRecord trigger with code like:

    If Test = '' THEN
    MESSAGE(Text50000);
    EXIT(Steps);
    END;
Sign In or Register to comment.