ok...this seams like it should be simple, but it's not working.

I want to pull a value list from my FMP5 db and display it in a pulldown / check box / etc field on an add form.

How does this work?

The format file that contains the value list tags must be returned from a post action that queries the database that contains the valuelist or the value list tags must reside in between the opening and closing tags of an inline action that queries the database that contains the valuelist(s).

In your case the database is not queried until the record is added. I would therefore recommend using either an inline action or use HTML dropdowns or radios - I normally use HTML - as long as the valuelists dont change too frequently you should not find yourself coding too much.

Use the FMLink applet for tags saves many typos

hope this helps

PS I like San Jose i'm here at the moment - Campbell actually - nice place

[ April 13, 2002, 02:48 AM: Message edited by: scratchmalogicalwax ]