Hi folks,
I was wondering is anyone had any tips on how to display only unique values
when pulling information from a secondary data source.

example: i have an sts list set up as a secondary data source and i put a
drop down list into my form to display the team names from the list.  as the
team names repeat, i only want each one to appear once.

I get around this by basically creating seperate list with with particular
fields that don't repeat actings as keys however there are times when i
don't want to create several lists.

Any suggestions?