Prompt values from a SQL as well as a custom value
Hem31Feb 3 2010 — edited Feb 4 2010Hi,
We have a requirement to put a prompt on State code. We have a master table for State codes. But in Transaction table (which is used in the report column) will have an extra value of State code which will not be in the master table. We want to show all state codes and this extra value in the prompt. How can I do that?
I can not use the transaction table as a prompt source as it may not have all states.
In short the prompt should show following results.
SELECT STATE_CODE FROM STATE_TABLE
+
Additional Values
Edited by: Hem31 on Feb 3, 2010 3:37 PM