I am trying to develop a value list to populate a drop down menu that would incorporate a list of layouts or field names in the current file.
The purpose is to map data out of a table that was generated from a raw import. First I would like to have the user select which layout shows the imported data, and then map a few of the key fields in that layout to the permanent data structure of the solution. Then the import will be processed by some scripts.
So I need one dropdown (value list) where the user makes an initial layout selection, and a second value list that populates dropdowns using the value selected for the target layout in the first dropdown.
I think this involves some self-joins, but I am running into trouble implementing it. Thanks for any help.
Mark
