2. ASPRunnerPro General questions
  3. Queries - Dynamic - User Selection
This topic is locked

Queries - Dynamic - User Selection

 		2/10/2006 12:09:57 PM
ASPRunnerPro General questions
C
 Chad author

I have a query I display. One of the fields is Division.
There is a Table tblDivision also.
Is there a way to have a dynamic drop down box to display tblDivision.Division and then take that selection and have a query run that says
select * from query where division=user selection
Sergey Kornilov admin 2/12/2006

You can do this on Advanced Search screen.
Theoretically you can mimic advanced search screen on the list page.
I'll try to implement this and post results here.
C
 		Chad author 2/22/2006

You can do this on Advanced Search screen.

Theoretically you can mimic advanced search screen on the list page.
I'll try to implement this and post results here.


Any results yet?
How would I do a a lookup on the advanced search screen?
C
 		Chad author 2/22/2006



Any results yet?
How would I do a a lookup on the advanced search screen?


Figured it out.. Thanks
A
 		ashumak 2/23/2006

So maybe share the wealth and let others know???
Alan
Sergey Kornilov admin 2/24/2006

To create a lookup on Advanced Search screen set "Edit as" type of this field to "Lookup wizard".