From: "Myles Wakeham" <myles@...>

>
> The user will select the party that they wish to invoice, then click
> 'Create Invoice'. At this time it will bring up an invoice entry form.
> But it will show an invoice number. The invoice record has been
> created in order to get a unique invoice number for the user doing the
> data entry at this time. However its not until they elect to save their
> entry that the invoice is considered 'processed' and therefore actually
> exists.

Myles, do a search for "auditable series of numbers" and you should come up
with some ideas about how to do something like this if you really need it.
My opinion is to never re-use numbers but I realize that occasionally some
requirement might need them.

HTH
Woody (TMW)