I have a table A which has children in table B (a 1 to many relationship). This relationship selects from B those records that match the relationship criteria and sometimes the corresponding records in B are the empty set (non found).
I have a layout based on table A (the anchor), but I want to filter the layout so that only records in A that have corresponding records in B show.
And, I want this to be done via a relationship that limits records in A to the criteria I just stated.
How can I do this?
A layout based on table A shows the records from table A.
You can do a find; and perhaps even attach it to a layout script trigger.
But if there are 100 records in table A; and 75 of them qualify; your record indicator, for instance, will show the found count and total record count of 100.