Sequential Number generator

[jagoldst]

I need help with creating a calculation that can number 100 created records from 1-100 sequentially without having to go into define fields and set the first number to 1 before creating them.

Thanks

JG

[signal]

If you create a self-join relationship with the database, then

Count(self_relationship::databasefieldname)

And assign your serial number to that, it would work but there are some pitfalls like what if a record in the middle is deleted. You may want to use something like

Max(self_relationship::databasefieldname) +1

[Ocean West]

Create a one record database. Add a number field: "Record No".

From your database control the creation of records with passwords, and via a scripted button. Then every time you create a new record. Set the field in this file via a relationship. To itself plus one. Then set the field in the local file to the new number. With a little work this system works fine even in multiuser environments. You need to add some additional scripts steps to prevent duplicates but it is possible.