Hi All,

I have a table of type values. I have fields ID, groupname, value etc.

I want to just get the groupname values from the table but I want these values to be unique. Hence I can have:

1 Status Current 2 Status Completed 3 Title Mr 4 Title Mrs

etc

Now I want to get a bind to a combobox only values Status and Title NOT (Status, Status, Title,Title).

I'm sure there is a way to do this but I am unsure how to.

I am using SelfService.

Thanks. Hameed

Create a dynamic list with just these 2 fields, then specify false for allowDuplicates, and you should get distinct values.

Hi Frans,

Off course I should have thought of that.

That worked like a treat.

Thanks