Search form to Database sort

[Erik Hardtle]

Sorry to probably bring up an old question.... I've searched thru the
frontpage websites I know and can't find the answer.

I have a database called HELPWANTEDADS.
It has ADNUMBER, TITLE, DESC, COUNTY as fields in Access.
I can send a search from a text box form to do a keyword search and it will
pull up any record that contains the keyword.
I use the CRITERIA setting in DRW for that.

Question: I want to add a drop down box for TITLE and another one for COUNTY
and the KEYWORD input box on a single form.
If the user selects a county only (no KEYWORD or TITLE) the results
should only show the COUNTY matches.
If the user selects a COUNTY and a KEYWORD the result should show only
data containing the KEYWORD sorted by the COUNTY selected.
If the user selects a TITLE and a COUNTY and a KEYWORD the result should
show only data that contains the KEYWORD sorted by the TITLE and sorted by
the county COUNTY.

I think I need a special asp query statement but I am not sure how it should
formatted... or is there a way thru DRW and my brain synapsis are not firing
right.

Thanks,
Erik Hardtle

 

[Stefan B Rusynko]

The DBRW can not do it in 1 page
-best you can do w/ the DBRW is something like at
http://spiderwebwoman.com/tutorials/doubledropdown.htm
Or hand coding the tweaks like at
http://home.att.net/~codelibrary/FrontPage/buildquery.htm

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Sorry to probably bring up an old question.... I've searched thru the
| frontpage websites I know and can't find the answer.
|
| I have a database called HELPWANTEDADS.
| It has ADNUMBER, TITLE, DESC, COUNTY as fields in Access.
| I can send a search from a text box form to do a keyword search and it will
| pull up any record that contains the keyword.
| I use the CRITERIA setting in DRW for that.
|
| Question: I want to add a drop down box for TITLE and another one for COUNTY
| and the KEYWORD input box on a single form.
| If the user selects a county only (no KEYWORD or TITLE) the results
| should only show the COUNTY matches.
| If the user selects a COUNTY and a KEYWORD the result should show only
| data containing the KEYWORD sorted by the COUNTY selected.
| If the user selects a TITLE and a COUNTY and a KEYWORD the result should
| show only data that contains the KEYWORD sorted by the TITLE and sorted by
| the county COUNTY.
|
| I think I need a special asp query statement but I am not sure how it should
| formatted... or is there a way thru DRW and my brain synapsis are not firing
| right.
|
| Thanks,
| Erik Hardtle
|
|
|
|