Hello!

Does anyone know if you can create fields in FMPro 5 dynamically, based on the selection of another field? Logically, something like this:

if (popup list) = x then insert into layout x fields x, y, z

if (popup list) = y then insert into layout x fields a, b, c

Thanks,

J

Design functions, such as creating layouts, fields, scripts, or altering any of them, are not scriptable within FileMaker. It's probably possible to script them using something like QuicKeys or OneClick, but there may be another way to do what you want.

I'm guessing that the purpose of this is to show certain information or hide it depending on selections made by the user. This can be accomplished in at least two ways.

The first is with multiple layouts. Each layout has fields present depending on possible user options. Which layout is entered is controlled through a script that detects the user options and takes the user to the right layout.

The second solution is more complex. It involves a feature of FileMaker that portals will only show the information within them when the relationship they are based on is valid. So you could place a field that you want to have appear and disappear based on user options inside of a portal that is only valid when the user options are correct.

Try going to databasepros.com and searching for "disappear". I believe there is a technique file that will demonstrate this fully.

Chuck

I'll check out databasepros.com but unfortunately I don't think the idea of having separate layouts will work in this case. Thanks for your help!

-- J