I have a table with invoices, and a table with the current invoice number. 3 users are connected to the server wich is hosting these tables.

I've been using the global variable function to store the most recent invoice number. I also have used the "Set field" function, something like this:

Set field: invoice number; number_table:invoice number

and then, I must update the invoice number so I use set field again and enter invoice_number+1

this works really great with one user, but not with 2, because the global variable is not global enough. It's only updating on the local computer, and not on every connected client.

How can I solve this issue?

because the global variable is not global enough. It's only updating on the local computer, and not on every connected client.

How can I solve this issue?

Globals are unique to each client.

Invoice number should be an AutoEnter field incremented by 1.

Michael

What kind of routine would you suggest would be the best in order to retrieve and update the invoice number?

Not usre why you would want to "Update" an invoice number.

Define a new field. Click on the options button>Check the box Serial Number> Choose the next value you want and increment by 1.

Then every record that is created will get a Unique Invoice number.

Michael