Hello

I've been having a good read through the forums, and I've looked through the manual - but what I can't find is an easy way of doing distinct selections.

All I've found is the way of using projections which seems to involve around 25 lines of code...

What I would like to do is look up some distinct values in one table and join it to another table so that when I bind to my listbox, I can have the value as TableB.ForeignKey and the text value as TableA.Name.

Is the projection method the only way?

Many thanks

Darren

by defination entities are unique so distinct is irrelevant. to use the key word query you need to fetch a projection, typed/dynamic list.

thanks jmeckley