AnsweredAssumed Answered

Finding records by comparing two date fields in releated tables

Question asked by BrianSmall on Jan 19, 2012
Latest reply on Jan 19, 2012 by philmodjunk

Title

Finding records by comparing two date fields in releated tables

Post

Hi,

 

Using FM Pro 11 on a Mac,

 

I'm trying to create a report for each parent record that lists all the test results for the parent that are after a date in the parent record. I have created a report and it has all the test records. I'd guess it's a find that I'm not thinking of in a FM way, I'm pretty sure I could do it via a loop and variables and create a temporary table to report off of, but that doens't seem to be a very optimal FM solution.

 

Parent Record:

Name, ID, Start_Date

 

Test Record

ID, Test_Date, Result1, Result2 ...

 

So for each Parent I would want any test records that are after the Start_Date.

 

Thanks,

 

Brian

Outcomes