how to create numbers automatically in subforms?

Manuel_A.

How can i automatically create numbers in Subforms if i go to a new line? for e.x. for the primary key?

1,2,3....
or
10010,10020,10030..... ?

thanks
Manuel A.

Waldo

last field of the key of the table of the subform :-k should be an integer .. and on the subform, you should use the property 'AutoSplitKey' ... .

Look at how "Sales Line and the Sales order Subform" is implemented...

Manuel_A.

thanks so far. It worked.

Now it creates numbers beginning from 10000 in 1000 steps.

This is what i need at the moment.

but how can i create numbers beginning from 1 in 1 steps ?

1,2,3.... ? Like its done in Table 32?

Waldo

You can use the "AutoIncrement"-property of the integer-field (key).

Ian_piddignton

Just so you are aware. The reason it increments in 10000 steps is so that it can handle inserting new lines between existing ones.

If you had 2 lines on the subform and inserted a new one between them it would get line number 15000

If you increament in 1's you won't be able to insert between exisiting lines, you just get an error.


regards

Ian

Manuel_A.

thank you for your answers!

Manuel A.