Open manage | database | Fields
Double Click the field where you want this
Click the auto-enter tab in the field options dialog that now opens
enter 1 in the data box and each new record will autumatically enter a 1 in that field for you.
Hi Phil, thanks for replying.
If I create a new record, and change the number to 2, then when I create the next new record, will it display 2, or will it display 1?
I don't want to have to go into the Manage/Database/Fields and change the value each time I want the number to be different.
For example, let's say the Storage Box Number field begins with 1. Let's say I want the first 15 records to have 1 in that field. However, with the next record, which would be Record 16, I want it to have the number 2, and continue to have the number 2 for the next 12 records. Can I do that without going into the Auto-Enter tab?
If I change the value in the actual form, and not in Manage/Database, will it continue to enter the new value, or will it continue to enter the value originally placed in Auto-Enter?
It will display 1.
You can enter a value in a global field or global variable then use the calculation option in Auto-enter to enter the contents of this field or variable.
Sounds easier just to fill it in manually. Thanks for the information! Jd
It depends on the functionality that you want.
An OnobjectExit Script trigger could run the following script:
Set Variable [$$CurrentValue; Value: YourTable::YourField]
Then the auto-enter calculation for YourField could be $$CurrentValue
Then each new record will auto-enter the value stored the last time you edited YourField in one of the records.