FM 15 Advanced - I am storing my value lists in a separate file (Value Lists). Problem: I want to allow my user to edit the value lists much as the Value List Custom Values feature does. I can certainly do it with hard coded script and layouts, but I would like one layout and one script that can determine which field is asking for the edit, load the appropriate values from the Value List table, display them, let the user change it and replace the edited entries back into the Value List table.
I get very close (and why doesn't this screen allow a cut and paste of our FM scripts???). I can determine the active field and store the Value List file path in a variable but when I go to store the contents of the Value List field in a variable, the Set Variable command fails
SET VARIABLE ($$ValueListContents; Value: $$ValueListTableFilePath)
The Value Lists table contains up to 25 fields each representing value lists from 25 different fields on the data entry screen. $$ValueListFilePath contains "Value Lists::Driveway Type Other" (value list entries for the entry field on the screen).
I'm sure that the script genies can solve this in a flash or I'm going to be coding into the night creating scripts for each of the 25 entries.