Multiple Queries / Pick-Lists for Database Results

[Brian]

Hi FP Community,

Got my .asp page and database working fine - have multiple
queries/pick-lists set-up and working and they basically help refine my
search results.

What I want to do though is somehow get those queries/pick-lists to work
separately to each other. Example:
Picklist - Golfer
Picklist - By Round

Currently I get the results by golfer name and the actual round - what I'd
like to do is get results by golfer for all their rounds or equally select
the Round and my results show the scores for each golfer from that round.

I've tried creating two separate queries/pick-lists but this seems to freeze
my results so can only assume I'm getting the sequence/process wrong if
indeed that is the solution!

Be grateful for some guidance please.

Brian.

 

[Stefan B Rusynko]

See http://spiderwebwoman.com/tutorials/doubledropdown.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
_____________________________________________


| Hi FP Community,
|
| Got my .asp page and database working fine - have multiple
| queries/pick-lists set-up and working and they basically help refine my
| search results.
|
| What I want to do though is somehow get those queries/pick-lists to work
| separately to each other. Example:
| Picklist - Golfer
| Picklist - By Round
|
| Currently I get the results by golfer name and the actual round - what I'd
| like to do is get results by golfer for all their rounds or equally select
| the Round and my results show the scores for each golfer from that round.
|
| I've tried creating two separate queries/pick-lists but this seems to freeze
| my results so can only assume I'm getting the sequence/process wrong if
| indeed that is the solution!
|
| Be grateful for some guidance please.
|
| Brian.