AUTO Populate a Form's Field with MySQL Table Field(s) Data

[tasc_redleader]

Hi,

I can easily make forms that add, edit/update, delete.

But I want to be able to populate a form field (usually a popup field) with a selection of records from a specific table.

Say I have a table: CARS

That has fields: MODEL, MANUFACTURER, PRICE

I want to populate the form field named Model with all the CARS:MODEL values in the table.

...and some times...

I want to populate the form field named Model with all the CARS:MODEL values in the table where CARS:PRICE < 20,000

Now, I am fine with the whole HTML, MySQL, PHP programming and can do this all by long-hand coding.

But I'd like to speed it all up and use Dreamweaver! 🙂

AND I'd like the edit/update forms to also selected the current records value and make it SELECTED whilst also holding all the other values..., using Dreamweaver.

I can do this all by long-hand coding, but I'd like to speed up my development (and colleagues) and use Dreamweaver! 🙂

I hope all we need is a pointer to which menu items to use for this way of working within Dreamweaver...

Thank you,

[bregent]

Take a look at DW's Dynamic Form Elements server behaviors.