Create new recordnumber + 1

[Jorgen]

Hi there,

 

Ik have 10 records. In the latest record the field "Tracknr." is filled with value 10. When i create a new record i would like to fill the "tracknr." field automatically in to 11.

How do i do this?Oh Really!

 

smiley-laughing Thanks Jorgensmiley-laughing

[cschmitz]

It sounds like you're trying to auto increment a serial number.

 

If you edit the options on your Tracknr field you can have it auto-enter a serial number. Set the next value to whatever number you want entered next (in this case that would be 11) and then leave it to increment by one on creation. That way every time you create a new record it will insert the next number value.

 

Be careful though. If you delete a record the count does not automatically go back and use the number that was deleted. If you want that kind of capability you'd need to have it auto enter a calculation.

[Jorgen]

It sounds like you're trying to auto increment a serial number.

 

If you edit the options on your Tracknr field you can have it auto-enter a serial number. Set the next value to whatever number you want entered next (in this case that would be 11) and then leave it to increment by one on creation. That way every time you create a new record it will insert the next number value.

 

Be careful though. If you delete a record the count does not automatically go back and use the number that was deleted. If you want that kind of capability you'd need to have it auto enter a calculation.

 

 

Thanks, it's working!

 

Regards Jorgen

[cschmitz]

Thanks, it's working!

 

Regards Jorgen

 

 

No problem. Glad to help