This option allows the user to add new values which will subsequently be added to the related table and therefore show up in the dropdown the next time the user enters a new record.

I want to create the same functionality for a Dropdown field using an on input script.

My problem is I am totally new to this and don't really know where to start. I am starting to understand Deluge but I haven't written a single script yet and I would like to get past this problem because the rest of my simple little database is functioning well.

The way I envision it working is:

A user selects a value of "Other" from a dropdown menu in a Dropdown field.

A text box opens for the user to input a "new value"

The user inputs "new value" in the text box.

On input "new value" becomes the value in the Dropdown field.

"new value" is added to the dropdown list.

"new value" shows up in the dropdown the next time the user enters a new record.

Any insight would be greatly appreciated. Thanks!