Insert missing serial number record?
I have a table for invoices. Instead of marking an invoice as void, I would rather delete the invoice, but this would leave a gap in the invoice ID's. Is there any way of inserting a record with the missing serial number field? So lets say I have invoice 1-100, and number 57 is missing, can I have a script to create a record without interfering with future serial numbers that are created?