Anyone have had this need before ? We have a query with 2 prompts ( BUSINESS_UNIT & DEPTID ) We have situations where users would enter only (a) BUSINESS_UNIT and (b) no DEPTID and they want to have the query selecting (a) only the BUSINESS_UNIT entered and (b) all DEPTID ( since user did not enter any DEPTID ) And same nature as they would like more prompts such VENDOR_ID, etc. Any idea or workaround you might have ? THanks