Subqueries across multiple datasource keys

   I just found out that you can't write subqueries for entities generated from different datasource keys.  I want to explain my work-around and see if anybody can think of a better way.

My screen has a simple search box and then a grid underneath that displays the search results.  One of the fields a user can search on is "Customer Name."  

My model looks like this:

VisitReport.CrmAccount.Name

A VisitReport exists in our "main" database, and then CrmAccount represents an account in our CRM database.  Name is a property on CrmAccount.

It would have been nice if subqueries worked across datasources, cause then I could have done this query easily.  However, what I ended up with is using the ListManager.  So when the user first pulls up the screen, we get all VisitReports and attach a ListManager to that EntityList.  The Predicate defined for the ListManager checks to see that searchTextbox.Text is contained in VisitReport.CrmAccount.Name.

Now as the user types, I've wired up the searchTextbox.Changed event to simply reset the resultsList.ListManager to itself, like so:

resultsList.ListManager = resultsList.ListManager;

It seems that simply setting this propery forces the ListManager to re-evaluate the list.

So, the question - is there an easier/better way to do what I'm trying to do?