Find 2 criteria, where the 2nd is dependent on the 1st
I'm building a scripted Report to be exported to Word. The script includes the find (that i'm having difficulty with).
I have a Person table related to a Notes table. Notes can be of 3 types: C, F, NS. (Conversations, FileNote, NextSteps)
My Report is basically to show who i've had conversations with during a given time frame (e.g. the current month) … Which people have i talked to (recorded as a C note), And, if any of thosepeople (and ONLY those people) also have any open Next Steps (NS notes), i want to include those in the Report.
Find#1 — I'm able to easily find the people with C-notes during the time period. Find#2 — However, i don't know how to THEN limit the next find (for open NS notes) to only the people who were found in Find#1. Suggestions??
(working in FM 11 on Mac OS 10.8)