I am new to Crystal Reports 8.5 Professional and VB 6. Is it possible to set up a parameter pick list for a CR report using a SQL query based on another user entered parameter, possibly stored in a report varaible? Or is there another way to accomplish this?

For example, user is prompted for a customer id and then based on that customer id, I need to build a pick list of customer service reps for that customer.