single records from database

[ud2008]

Sorry for the title, I didn't know how to name it.

But here is what I want to do.

I know how I can get records from a database, but I have a table which contains a column and in that column are multiple records using the same group, like:

Group1
Group1
Group1

Group2
Group2

How can I (when I retrieve all records) get only single group names, group1, group2, because this is what I need to add to a combobox.

Thanks

 

[jmcilhinney]

Perform a query to retrieve just that column and use the DISTINCT keyword (or equivalent for your database) to remove duplicates.