Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

prompt search with multiple query objects

Status
Not open for further replies.

Namh

IS-IT--Management
Mar 22, 2006
21
US
Hi Everybody,

I have a big issue with a prompt interface.
I want 2 prompts. One drop down prompt where I can choose which Object (Field) I'm searching in and furthermore a multi-searchprompt which uses a Object (Field) depending on my drop down prompt.
for example:
I have a view called Customer with following attributes:
- CustomerID
- CustomerName
- CustomerCity

In my ddl I wanna choose now one of those three attributes.

And in my search list I write in the value and than, when I hit the search button it should search in the colum I decided in my ddl.

I tried many things. But couldn't find a working solution. IF and Case doesn't work in filters as far as I know.
If anybody has an Idea would be great!

Many thanks to any response,

Namh
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top