ID incrementing for multiple users - please help

[eluser]wiredesignz[/eluser]
Store the next invoice number for each user in their account details table and manually increment it.

Store all the invoices in a common table, index each invoice number with its owner account id + unique id