List multiple choices in combo box once

[t3nchi]

I have 2 cbo boxes : Year and Company

A certain year might have multiple entries for the same company. I want to have the company listed once instead of multiple times. How do I do that?

Thanks.

 

[MStCyr]

Simply use Select DISTINCT Company for the Company Combo

 

[t3nchi]

thanks mst