When the "Other" selection is made on a "Allow entry of other values"
I have a solution with a popup menu field whose value is the FK side of a relationship. When the user selects the popup, the "name" field of all the records in the parent TO is shown (show only values from second field).
I have it set to "Allow entry of other values." But it doesn't add new records to the Parent table.
Is there a function or script function that corresponds to when the user selects "Other?"
I'd like to have a script that basically does this:
If the user selects "Other"> go to the parent table and create a new record. Place as it's "name" field the value that the user types in.
This seems to me that probably some others have run across this same scenario, and wondered how to handle it.