Hello,

I have a list of sales rep names in one list box that I'd like to have
associated with multiple records of their sales in a second list box on a
form. Essentially, when a user clicks on a name on the left list box, the
right list box displays all the sales in the database under that name in a
one-to-many type relationship. I'm having a little trouble figuring out the
right approach for this. Should I add code to the left list box to query, or
is it better to use a sub-form here?

Thanks!