This is probably simple to you guys, but i really couldnt find a way to make this work. Need some help.
I have a table "Invoice"
and a field "Invoice ID"
Normally people will just make the field to be an Auto-Enter Serial Field.
But I do not want the serial to be created by itself.
There is many records, my client do not want to assign a serial to it if the invoice is not confirmed. Sometime she just want to keep the record inside and put the status in Pending, to change item, goods qty and price ect to get a rough total amount or do anything she want until it is confirmed.
When the invoice is confirmed, she need a button to press and assign a new serial number to "Invoice ID".
Unconfirmed invoice ID will always be blank.
New Invoice ID should use the previous ID +1, let's say we have 10 IDs, 1,2,3,4,5,6,7,8,9,10
the next New ID will be 11 when i click the button,
when the last record 11 is deleted, the next new ID should be 12, working like the Auto Enter serial function, it have its own Next Value stored.
Can this be done?