Jimmy,
You are right, invoices should be sequential, without gaps. Because of this, I don't think an invoice record should ever be deleted. If an invoice is printed, and the user deletes it, it should in reality be VOIDED...just like you would a check in your checkbook. The record should remain on file, with a zero amount, but marked as voided. Also, if you keep hardcopy invoices, the invoice should be printed out in its voided form and kept with other invoice copies.
Just my $.02.
>
>I think I will follow McCalland sugestion to recall the deleted record, because the PK is my invoice-number (The invoicenr. should be unique and it should be a numeric sequential number [1,2,3,4,5,6] or else the IRS will complain.)
Steve Gibson