Filtered Value List and...

[SteveB]

Using FM8 Advanced on Win:

I have a filtered value list built from records in a Valuelist File. The list is attached to a field called 'City'. If the user enters a value that is not already on the list, when I left the layout via a button, I would run a validation routine that checked the value, and added the record automatically to the filtered list. It worked, but the new value was never available until the user left the layout.

I tried using EventScript to run a small script when the user leaves the field. The field is validated by a calc, which calls the script to add the new field. If the calculation option 'Do Not Replace Existing Value For Field...' is checked, the script never gets executed. If it isn't checked, the script runs and adds the value, but when it returns to the layout, the new value is not in the field, and it would cause the user to click on the list again.

Anybody have any ideas on how to make this work correctly? What methods do you use to auto-update filtered valuelists when new values are entered? How do you allow the user to delete values?

Steve

[overrider]

i just have a self joined relationship city = city, then make a value list off that. this way once you have someone enter a city which hasnt been there before, it will appear in the value list from now on without any scripting. you just have to leave the field once. the issue is of course that if i today enter Frankfurt and tomorrow Frank furt i have two values for the same meaning....using the new auto complete feature could help avoiding mistakes though.