Subject Re: Invoice number From Heinz Kesting <Nobody@Nowhere.com> Date Sun, 6 Sep 2020 10:29:22 +0200 Newsgroups dbase.getting-started Hi Bami, > Hi all, > > I created invoicing app for a customer and it's working fine on standalone. When working under multiuser, it assigns one invoice number to two users. > > The invoice numbering is no more unique. I need advice on how to go about this. In addition to what Ken has said, I would recommend to make the field which holds the invoice unique, details for this depending on what database system you use (DBF or SQL servers). Then put your code that creates the invoice number into a TRY/CATCH ENDTRY construct. This way you can avoid creating doublettes of invoice numbers and can display a warning for the user, just to let him know, and cancel the process. Kind regards, Heinz