I have a form with a superset of data in its foundset and a subform using a relationship to display a subset of the data in a tab panel. When I run a query against the superset foundset, no matter what I try, the subset will not update.
What I think should work is:
- Code: Select all
forms.main_form.foundset.loadRecords(sql, args);
foundsetToUpdate = forms[tabFormName][subFormElements.getTabRelationNameAt(tabIndex)];
foundsetToUpdate.loadRecords();
The foundsetToUpdate code is definitely returning the correct relationship foundset. Even if I call the subform directly with a loadRecords() then the foundset from the superset is not reflected in the subset, nothing changes. I have output the size of the superset to confirm it is being correctly updated by the sql.
I cannot loadRecords() directly into a related foundset, which is fine, though this is only fine if the relationship data can be updated
Any help on this would be much appreciated.