AnsweredAssumed Answered

Find 2 criteria, where the 2nd is dependent on the 1st

Question asked by vlight on Dec 30, 2013
Latest reply on Jan 2, 2014 by vlight

Title

Find 2 criteria, where the 2nd is dependent on the 1st

Post

     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)

Outcomes