Can I back-propagate the "other" value in a list?

[dtrusty]

Hi,

I have a ValueList which I'm using for data entry on a form.

The ValueList originates from a field in another file.

I want the user to be able to use "other" to enter a new value,

but then I want to automatically update the file where the valuelist

pulls its values. In other words, the next time the ValueList is shown,

I want the new value to show up.

Is there any way to do this?

Thanks in advance!!

David

[Lee Smith]

If you are using a Value List from a related file, you can add the Edit in the Current File. However, if you are using a Field as the source, I don't think it can be done, because you would have to create a new record for each new item.

HTH

Lee

)

[Vaughan]

Lee is spot on. The only way to add to the value list is to add another record to the other file.

Now there may be a way to automate the process. It could go something like this:

Get rid of the "other" item fom the pop-up list and make a button on the layout with "Other." When people click on the button a script runs that brings up a custom dialog that lets people enter the new value. The script then validates the entry (checks it is unique, not empty, etc) makes a new record in the other file, enters the value, then returns to the original file and layout.

There may be ways to do it in earlier versions without the custom dialog script step, but it makes the process much easier and tighter.