How to make a list box of options prompt?

[JoelR]

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')#

[hauge9]

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.