Continuous Forms

[vanny]

I have a Continuous Form and the first Field of the Form is the Order number having Input Mask "A01-07-"000;0;

I want to make the last 3 digits of this field to be written down automatically and incrementing the number, once the user goes to the next line. Thus :

Line number one in the form should show : A01-07-001
A01-07-002
A01-07-003

Any suggestions of how I can go about it?

Thanks

 

[gemma-the-husky]

probably in the before insert ievent, do a dmax to get the highest number in the table, and add one to it

 

[vanny]

Can you please elaborate more on this subject..

I mean the field OrderNo is an Autonumber, do I need to get the DMAX for it?