Database Results Region and Drop Down Box Search/Filter

[swalt]

I have a Region that returns all records. What I would like to have is drop
down boxes (3) that allows user to select from drop down boxes and then have
the selection returned and displayed in the database region.

I have created search form for doing so but info has to be enterned into box
and not selected.

 

[PaulR]

In FP, click and highlight the input box. insert another database results
region, but this time at the very end, choose drop down.
The second region will input data to the first and give you the
functionality you require.
Regards
Paul

 

[swalt]

Ok close. Now drop down boxes are populated by records under the particular
field. Which is ok but in my case I have a database of year make and models
meaning I have multiple "2007" and so on listed in drop down box. This is a
database of cars. Any suggestions ?

 

[Kathleen Anderson [MVP - FrontPage]]

Add the word DISTINCT to your SQL statement, like this: s-sql="SELECT
DISTINCT modelyear

--

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

 

[swalt]

Ok I'm over my head if you can't tell. Her is my statement. Where should I
modify it?
SELECT * FROM exportvehicles

 

[Kathleen Anderson [MVP - FrontPage]]

s-sql="SELECT DISTINCT modelyear FROM exportvehicles (assuming modelyear
is the name of your field that contains the model years of the cars)


--

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