Populate List/Menu in Update Record form

[Swn-Y-Mor]

I am creating an update record form that contains a list/menu (with values General, 2002, 2004, 2006)

How do I populate this menu so that it pulls current value from database, and not just the top default value each time?

[Newsgroup_User]

Swn-Y-Mor wrote:
> I am creating an update record form that contains a list/menu (with values
> General, 2002, 2004, 2006)
>
> How do I populate this menu so that it pulls current value from database, and
> not just the top default value each time?

Select the menu object in the form. Then click the Dynamic button in the
Property Inspector. In the dialog box that opens, click the lightning
bolt next to Select value equal to. Finally, choose the data field from
the correct recordset.

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/

[Swn-Y-Mor]

Brilliant,
Thanks for the quick reply
Works like a dream

[Swn-Y-Mor]

Whoops - spoke too soon,
My update form displays correct drop down value, but when I submit the update it inserts a blank value into my field

[Newsgroup_User]

Swn-Y-Mor wrote:
> Whoops - spoke too soon,
> My update form displays correct drop down value, but when I submit the update it inserts a blank value into my field

That's got nothing to do with selecting the correct value in the first
place. There's something wrong with the way you have set up the Update
Record server behavior.

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/

[Swn-Y-Mor]

OK,
Got the list to populate dynamically, although I have an issue with my "update record" page. For some reason, any dynamic list/menu that I add, the record ID shows up as one of the options (at the bottom of the list).

[Swn-Y-Mor]

Any suggestions?