drop down menu from database

[Guest]

How can I get a drop down menu to use data from a database? (ie when choosing
a country I have a list of countries in a table and do not want to have to
enter them one by one in the drop down form)

 

[Kathleen Anderson [MVP - FrontPage]]

http://support.microsoft.com/kb/235554

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[Guest]

Hi. Thanks for prompt response. I think that I only need half your reply. But
am not sure.

This is what I want to do: I have a page where members have to fill a form
with their address. I want to give them a choice of a drop down menu for both
the State and Country. I have a table in a database which includes all states
and all countries. This table has three fields ID, Datatype (i.e. state or
country), and Value (i.e. AZ, CA, USA). How can I do this?

The membership form then feeds a members database.
Thanks,
EdH