i'm not sure how to explain this, but i'll try

i have 4 tables:

Foo fooID, ... Customer with customerID, fooID,... Worker with workerID, fooID,... CustomerWorker with CustomerWorkerID, customerID, workerID

Foo 1:n Customer Foo 1:n Worker Worker 1:n CustomerWorker Customer 1:n CustomerWorker

i want to have an editable grid for CustomerWorker, but i only know the fooID. so i have a fooID, get me all the CustomerWorker-records that basically have the same fooID

at first i thought, let's get me a typedview for CustomerWorker with fooID added. but then i cannot edit and update the CustomerWorker database

is this possible in an easy way?

CustomerWorkerCollection customerWorkers = new CustomerWorkerCollection(); RelationCollection relations = new RelationCollection(); IPredicate filter = PredicateFactory.Create(WorkerFieldIndex.FooId, ComparisonOperator.Equal, myFooId); relations.Add(CustomerWorkerEntity.Relations.WorkerEntityUsingWorkerId); customerWorkers.GetMulti(filter, relations);

the section 'filtering and sorting' as well as the northwind demo apps have some of this code present and can help you finding the right code