Hi, we have a table Company with COmpany Information, and some fields, for example: InvoiceNumber.
And then we have a simple table created Invoices.
We need to Get the number indicated in CompanyInformation and Verify if this not exists in table Invoices, and then, assign to Invoice. Then, when the invoice is saved, verify that another computer/client has not used this number, and if exists, then go to the next number, and then update the Comapny.InvoiceNumber.
I think it’s the best way to avoid having gaps in numbers.
Can you provide a simple project with 2 Screen that make’s this operation?