My SQL code creates a prompt where the user must type in the name of the person he wishes to get results on. How do you make a prompt that displays a list of names to choose from? My people look-up sql code currently looks like this:
EXC_PERSON = #prompt('Parameter1')#
If you are using custom SQL I think you need to create a separate query to populate this list.
Something along the lines of "select unique(exec_name) from....". Then specify for your list box to use this query.