hi all , i'm not sure am i doing the right thing ,
i have one table , named tbl_invoice_number and contains
invoice_id column as integer
another table tbl_temp_invoice_number contain temp_invoice_id
scenario 1
-----------
application will check table tbl_temp_invoice_number first,
- if temp_invoice_id is not null, tbl_invoice_number.invoice_id will copy value into temp_invoice_id
- else it take tbl_temp_invoice_number.temp_invoice_id as running number
scenario 2
----------
if other application check in and query,
- if tbl_temp_invoice_number.temp_invoice_id is not null, then return an increment id of tbl_temp_invoice_number.temp_invoice_id as running number
-else tbl_invoice_number.invoice_id will copy value into temp_invoice_id
and take it as running number
scenario 3
-----------
when one of the application save the invoice, tbl_temp_invoice_number.temp_invoice_id value will be clear
-- but the doubt is how application know should increase tbl_temp_invoice_number.temp_invoice_id or just take the tbl_temp_invoice_number.temp_invoice_id ?
believe still have many scenario have not cater yet ...really confuse on it
[ November 17, 2006: Message edited by: Nakata kokuyo ]