How to sequence the primary key

[jsnunez]

Hello all

I have a table "invoices" I want to increase the Invoice number ,evey time a new invoice is added to the table. I do not want to use an autoincrease field.

How can I do that?

thanks
jsn

 

[OnTheFly]

At the time the record is saved you would have to query the table with the invoices for the Max value and then increment it 1 and use that as the invoice number. If you have more than one person working in the database at once you definately have to do this at the last minute or you could end up with a duplicate.

Hope this helps.

OnTheFly