In VFP, I could get a subset of data from the server and then turn around and query that data subset to populate filter lists. This reduced hitting the server 2 or more times down to 1.

How can I (or can I?) do something similar to the above? (Not looking at LINQ.)My current thoughts is that I have to loop through the data and pick out the unique values. Is this the best/only way or is there some alternative that I haven't stubbled upon yet.

TIA
Richard