I have a parent table (Series) and a child table (Subscribers). I want to identify, flag, and delete records in the Series table with no corresponding records in the Subscriber table.
One way would be to loop through the Series table and use GTRR to identify parent records with no children by capturing the GTRR error code (101).
Another approach would to add a summary field to the Subscriber table (to get a record count) and use an auto-enter to populate a field in the Series table.
Any other approaches I should consider?