Hi
I'm having trouble finding how i can solve the following issue.
Suppose I have a MainEntity which has a collection a subobjects (1:n relation) accessible through MainEntity.SubObject
It is then easy to bind the subobjects to a datagrid using:
dataGrid1.DataSource = MainEntity.Subobject.;
The subobject collection can also be sorted first before binding it using :
MainEntity.SubObject.SupportsSorting = true;
Mainentity.SubObject.Sort(((int)SubObjectFieldIndex.Fieldname,ListSortDirection.Descending,Comparer.Default);
Now my problem is that i want to sort the SubObject collection using a criteria field that is not part of the SubObject record, but some 1:1 related entity (of SubObject) Let's suppose the SubObjectEntity is 1:1 related (or m:1, doesn't matter) to AnotherObjectEntity, and AnotherObjectEntity has a SortOrderField according to which I want to sort.
So something like SubObject.AnotherObject.SortOrderField. How could i achieve this ?
