Hi
My problem is I donot know how to generate a number without using autonum
which is unsuitable .

"Fred" wrote:

Under my described thought process, you would create the record in the
invoice table and create an invoice number at the time that the invoice event
occurred. The first printing would happen a few seconds AFTER that process.
And later you could print extra copies of that invoice if needed.