Problem with automatic number field
Operating system version
Windows XP Pro
Description of the issue
I have a database of around 5000 records, the first field of which is an automatic reference number.
Recently I started adding a record using the web published database and cancelled the record half way through.
When I went back to add a record it wouldn't allow the same number in the automatic reference field - it automatically goes on to the next number. So after this point the number in the reference field doesn't match the number actual number of the record. Any way to remedy this?