Finding records by comparing two date fields in releated tables
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.
Name, ID, Start_Date
ID, Test_Date, Result1, Result2 ...
So for each Parent I would want any test records that are after the Start_Date.