Populating a list/menu with table data (non-unique)

[wraygun]

Hi there,

I have a table (pictures) that has a unique field (pictureid) and several non-unique fields. I would like to populate a list box with the records that will likely have duplicates (username and galleryname). I want to populate it in a way that there will be no duplicates in the list/menu, even though there are duplicates in the database. I can't seem to wrap my mind around the logic to get this done. Any help or pointers would be greatly appreciated.

Thanks so much,
Harold


***You can't change your past, but you can change your future***

 

[Kozusnik]

Take a look at "GROUP BY field_1,field_2". Also "SELECT DISTINCT" can sometimes be used.

Not sure what your code looks like, so I can't suggest one or the other.

Mark