AnsweredAssumed Answered

Problem with automatic number field

Question asked by DeuanJones on Jun 15, 2011
Latest reply on Jul 22, 2017 by quirkycrone

Summary

Problem with automatic number field

Product

FileMaker Pro

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?

Outcomes