I have just been assessing the product and I was thinking this would be a very common requirement. For example, we group companies we sell parts to so we can apply discounts etc. We have about 40,000 CompanyGroups and these link to about 60,000 Companies. Obviously for performance reasons one wouldn't even consider loading all of these as the form loads. I set my relationship between them at design time.
To keep the application memory to a minimum on the client the top level data (i.e. Company Group) is loaded 50 records at a time. My thinking was to keep a small cache of associated Companies and add records to it as the user expands the group and remove records as it is collapsed.
Here is the code;
So this begs the question; how do we force the child grid to refresh?