Hey guys I have a client who need a report that allows him to input codes on one search and select prompt then be able to see and search names on another search and select prompt but I'm having difficulty.
I currently I have 5 queries
- pYear
-PCountry
-pCode
-pName
-MainQuery
Within the pCode Query I have just the Code value. Within the pName Query I have the Code and Name value.
Now in the prompt page I have two search and select prompts with the top being the code as this is the prompt that needs to filter the name prompt below it.
When I created the name prompt I went through the usual process and made the cascading source the code prompt and created a reprompt button. However, when I use a value prompt this process works but for a search and select doesn't seem to work. Is there something I'm getting wrong?