Value list to include Field or Layout Names

[Mark Hart]

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

[LaRetta]

Hi Mark, welcome to FM Forums!!

Check out FM Help on the Design Functions, particularly LayoutNames() and FieldNames(). :wink2:

Edited November 23, 2008 by Guest