Filling dropdown list with DB info?

I'm curious, how do you specify a dropdown list to pull the list info from a
database (like MySql) field?

Thanks,
Steve

Steve Grosz wrote:

I'm curious, how do you specify a dropdown list to pull the list info from a
database (like MySql) field?

Depends on what the dropdown list is going to be used for, but it's
fairly easy. I'm assuming you know how to insert dynamic data into a
page using a table or dynamic text; if you don't, you'll have to read
some tutorials over at the Development Centre. Center. Sorry.

First, you need to designate your page as a dynamic page. (I use php
mostly).

Then, insert your dropdown list, like you would normally. (Under Insert:
Form; you need an .html list before you can make it dynamic.)

Because your page is now dynamic, you'll see that you can enter values
the old fashioned way, or you can click on the "dynamic" button, and use
values from recordset. Then, just pass your link through the value of
the id_tag, and you're set to go. (You can also go to the Server
Behaviour panel, but it's easier just to click the dynamic button that
shows up in the property inspector.)

It's about that easy. Again, this is assuming you know how to use php
(and, up until two weeks ago, I didn't, so that's how easy it is) or
coldfusion or whatever.