Hi all,

I have a problem with the database I'm crating. Not sure how to do this exactly. Would appreciate any help / suggestions.

Situation is as follows:

User requested in invoice database to include invoice number field so hi can enter invoice number. I done that, then he additional requested that number in the field should be increased by one every time that he opens new record(that's not a big deal). Main problem is that he don't know for sure from which number will count start and want me to leave it optional for him to write it down by himself and only to do it 1 time in 1st record and when he opens new record and so on each time to go automatically( written and increased by 1).

Not sure how to do that exactly.

Thanks in advance.

You could have the user enter the number in a Preferences table (or in a global field, if it's a single-user solution, e.g. a runtime). Then add the user's offset to a serial number starting from 0. Another way would be to set the next serial number by script.

I'd be very careful with it and only allow the user to do this while there are still no records in the Invoices table.