...
2) Prompts via ‘Prompts’ tab:
- Select the ‘Prompts’ tab.
- Select the yellow ‘Add Prompt’ button.
- Under ‘Field Name’, click on the search icon.
- Enter the full or partial name of the field and click on the yellow ‘Search’ button.
- One or more options may appear. Select the field that you want.
- Edit the prompt properties.
- Change the ‘*Heading Type:’, ‘*Type:’ or ‘*Format’ fields, as desired.
- Change the ‘*Heading Text:’ to what the prompt should read. This is what the query runner will see.
- Change the ‘*Edit Type:’ to reflect the editing for the query. ‘No Edit Table’ allows the query to run if the prompt field is blank (important for optional prompts). The other three options require a value in the prompt field for the query to run.
- In the ‘*Prompt Table:’, select a table which will validate the value in the prompt field. This is available only if the ‘*Edit Type:’ is ‘No Edit Table’ or ‘Prompt Table’.
- Select the yellow ‘OK’ button, which returns you to the ‘Prompts’ build page.
- Hit the yellow ‘Save’ button.
- Use the new prompt is the Criteria tab.