Do i need another table to store the deleted invoice no.? RRS feed

  • Question

  • Hey,

    If i have a table to store the invoice number. example, start from 0001. the second will will automatically ++1. then update the new inv no. into this table.
    (Will only have one record in this table all the time)

    Senario.. when the inv no. go until 0009... People might need to cancel or delete the 0005 invoice... And they want to use back the 0005 inv no. for the next invoice...

    Do u think i should create a another table (inv_temp) to store the deleted inv. no. And check this table for data exist every time you want to create a new inv.

    Wednesday, December 12, 2007 10:29 AM