Invoice No's

[Sari]

Hi,

I've set up our database to use an incremental number on the creation of a new record. However, if anybody accidentally creates a record and then reverts it, we lose an invoice number and it throws the accountants into a panic!!

I presume I need to calculate this in some way? Can anyone help?

Many thanks

Sari

[SlimJim]

Your description of the problem suggests that the panic occurs when they are asked whether or not to commit the record and at that point they revert. If that is the only problem you could try having the serial number entered on commit rather than on creation. But this could lead to other problems if you are using portals via the invoice number to enter data.

There are other ways that you can auto-enter a serial number which will take care of the most recent entry being deleted - but I know of no automatic method of filling in the holes if earlier entries are deleted.

For example make a second TO of your invoice table, Invoice 2, relate by cartesian product and then set up an Autoentry in Invoice number of Max(Invoice 2::Invoice Number) + 1.

[Sari]

Hi,

Why would I need to have a second TO of the invoice 2?

Thanks for the help, by the way.

[SlimJim]

The second TO allows you to evaluate the Max over all the records.

[Ano Nimus]

Maybe this helps?