Continuous Forms 1

[Angelique21]

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

 

[Angelique21]

Thanks a lot for your valuable and detailed help.

Appreciated.

Thanks once again..

 

[Guest_imported]

In the properties box
Field size Long Integer
New Value Increment

\A07"07-"000

 

[Remou]

Dick003425
That is a format. Is it a good idea to show a primary key as containing something that it does not contain? Especially if next year OrderNo is to start B08...