Understanding Prompts

Adding a prompt lets you further refine a query when you run it. For example, suppose that you want to change a query so that you could prompt the user to enter a value for the duration of a vacation. Before you add the prompt, the query always retrieves rows for employees who had taken vacation based on a defined constant value on which to make a comparison. Adding a prompt to the query enables the user to enter any duration, and then the query can return employees based on the value provided when running the query.

When you run a query with a prompt, a prompt page requests the required value. All date, time, and datetime prompt fields are required fields when running Query. The query uses the value that you enter as the comparison value for the criterion that included the prompt.

If the field you are prompting has an associated prompt table (even if it is the Translate table), the Edit Table drop-down list shows its name.