records numbered sequentially
I'm working with a database that was created by someone that is long gone. There is a field that assigns a sequential registration number. WE would like to be able to either reset this number to begin at 1 for a new database or change the field so that we can enter a number on our own. If we try and enter a number over what is assigned, the whole record does not show in the report screen - but we can change the number again on the report screen and the record will then show.
I'm a Filemaker newbie and not sure where to look for this type of formatting. Double clicking on the field in the layout screen brings up an inspector - but nothing there seems to indicate a sequential number field.
Any help here is greatly appreciated.