I have a pass-through query pulling in the data I want....from Oracle OBI ODBC
It works fine -
The Issue I am having - I need a way to have a user narrow the query thru a form...
Drop Down or Text Field Entry in a Start Up Form that the user can then limit the query to.
I would like to include a prompt in the query - but pass-through doesn't accept it
WHERE ("- Standard Calendar"."Day Date" =CURRENT_DATE) AND ("- Organization"."District Num" = '01')
WHERE ("- Standard Calendar"."Day Date" =[PROMPT DATE]) AND ("- Organization"."District Num" = '[PROMPT DISTRICT]')
WHERE ("- Standard Calendar"."Day Date" =[FORM]![FIELD1]) AND ("- Organization"."District Num" = '[FORM]![FIELD2]')