DropDown boxes in query forms

[Joe Blow]

I am using the basic database results region. I have it working perfectly,
with the text boxes it creates in the search form, but I'd like for one of
these text boxes to be a drop down box with the possible values displayed as
choices. Is this hard? I'm not a coder, but love building these little
apps. Also, when setting up a data base connection, how can I get fields
from 2 different tables in my SQL database? It seems FP only allows you to
choose 1 table to report fields from.

Thanks
Heath

 

[MD Websunlimited]

Hi Joe,

The DRW will you to select a drop down for the field values.
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp


--
Mike -- FrontPage MVP '97-'02
http://www.websunlimited.com
Need to run ASP pages without a browser or server? Take a look at what RunASP can do for you.
http://www.websunlimited.com/order/Product/RunASP/runasp.htm
FrontPage Add-ins Since '97 2003 / 2002 / 2000 Compatible

 

[Joe Blow]

Thanks, does this mean I would need to do 2 results regions, one to specify
the dropdown and have it submit to the 2nd for my actual database list based
on the query of the first?

HC