Increment by 10

aquincoaquinco Member Posts: 16
Hi guys :)
I have a table Transport Line and I want to increase value of field "Line No." by 10 when I go to a new row.
How can I do this without No. Series?
"Line No." is my primary key.
I tried this code but it doesn't work :/

Line No. - OnValidate()

IF "Line No." = ' ' THEN BEGIN
Lines.FINDLAST;
"Line No." := Lines."Line No." + 10;
END;

where Lines is rec variable of my table.
Thanks in advance :)

Best Answer

Answers

Sign In or Register to comment.