Hi,

I'm not sure if I can do this, but I've learned that if you can imagine it, there is generally a way to do it.

What I would like to do is have a value list of layouts. The idea being that the user could choose a layout and go to it (via a script based on the number value of the layout). The list would only be some of the layouts in the database also the list would have to be self editing to grow or shrink as layouts are created.

I thought of having a database which contains just the layout titles and a way of distinguishing which should belong to the value list, and then have a calculation field based on the content of the selected layout.

Not sure if this makes any sense, but any help would be great. Thanks

Check out the Design Function called "Layout Names". It might be useful.

I've been trying to get the LayoutNames() design function to insert the layout names into a field. I've tried having a calculation field set to LayoutNames("MainDB"), I've tried setting a text field with a script using the Insert Calculated Value step, I've tried this with a global field... I can't seem to make it work.

I'd like to have the list be inserted into a global field by a script... if this is possible how do I do it? I'm stumped!

This works for me.

Set Field [ "globaltextfieldname", " LayoutNames ( "AnyDB.fp5")"]

I just tried it in version 5 and had no problems.

What version of FM? I have a simple demo I wrote of precisely what you want to do but it is in FM7 and uses a free plugin (supplied by Filemaker) that is attached to the file.