November 20, 200817 yr Newbies 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
November 23, 200817 yr Hi Mark, welcome to FM Forums!! Check out FM Help on the Design Functions, particularly LayoutNames() and FieldNames(). :wink2: Edited November 23, 200817 yr by Guest
Create an account or sign in to comment