I have two related tables, let’s say tablea is parent of tableb. There is forma based on tablea which includes a tab-panel which includes tablea_to_tableb.formb which is a tableview of tableb.
All’s well insomuch as the tableview in the tab-panel shows the child records in tableb of the current parent in tablea.
But… I wish to “filter” the child records based on a “status” field in tableb. Just to complicate things, this status field in tableb comes from a different parent of tableb, let’s call this tablec. Also, I can’t assume that we’ll only be interested in contiguous ranges of values for this status field (otherwise I’d use a relation with “>=” and “<=” conditions).
I’ve tried scripting a find() on tableview form, but no matter what I do the result displayed in the tableview in the tab-panel is always the full set of child records of the current tablea record (i.e. the filtering is innefectual).
Is the set of records in the tab-panel form somehow being refreshed after I execute the scripted search?
FWIW, if I display the tableview of tableb child records form by itself (i.e. not in a tab-panel) I can successfully execute the filtering search manually. Aha, also if I copy the filtering method to formb (the tableview of tableb) and run that method while formb is displayed by itself then it appears to get the desired (filtered) result.
Should I not also be able to do this when formb is displayed in a tab-panel on forma?
Thanks,
Neale.