Finding Child records based on Parent records found set
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).