Greetings,

I am trying to create a database that will automatically create a document number when the user clicks "Create New" button. To do this, I have created another table, which I will used as a counter of sorts. It will keep track of the last number used, and when the new document is created, it will up the number by one in both places. I am not sure how to access the counter from the scriptng page, though. There are more than one type of document, so it will have to be able to find the exact field I am pointing it to, and change it after the creation process is complete.

If anyone can help me with this, I would be very grateful!

Thank you,

A.

Hello and welcome!

You could define one table for each documenttype, each table consisting of just one field with an auto-entered serialnumber.

The 'Create New' button would then have to create a new record in the table for the corresponding document type, read the serialnumber field and copy it to a serialnumber field of the main document table.

Ernst.

Thank you so much for your quick response!

A.