AnsweredAssumed Answered

Finding Child records based on Parent records found set

Question asked by ChanhThach_1 on Apr 2, 2015
Latest reply on Apr 3, 2015 by philmodjunk

Title

Finding Child records based on Parent records found set

Post

I have 2 tables in a one to many relationship and are linked together with an ID number. The Parent table has a date field on when the record was made. I want to be able to find all the records in the Parent table that were made in the last 30 days, then use the ID number to find all the related child records.

So far I am able to find all the records made in the last 30 days in the Parent table, but I am not able to figure out how to find all the Child records that belong to all the records in the Parent table (found set).

 

Outcomes