Hello - I would like to have a script where the user can automatically be prompted to enter a month from a value list and that answer will update an auto enter field from define database. I know that it can open the entire define database but I don't want them to be able to make changes to the other fields - in short making it fool proof! Thank you.

Hello - I would like to have a script where the user can automatically be prompted to enter a month from a value list and that answer will update an auto enter field from define database.

I think you want to make a global storage field. Have the user fill in its value with a value list. Make your auto-enter value fill in using a calculation with the value of this global field.

Sorry, can you clarify this a bit more? I don't understand.

never mind. I got it! Thank you so much!

I presume that you want to edit the value that the auto-enter feature uses for new records. Your current situation is that a field (e.g. TheMonth) is configured to have an auto-enter value of Data: "January".

Create a text field named gAutoEnterMonth

Make its Storage setting to be Global.

Edit the auto-enter options for the field TheMonth.

Make it auto-enter calculated value with the calculation = gAutoEnterMonth.

Put gAutoEnterMonth onto a layout for the user. Let the user fill in its value using a value List.