I am trying to create a report of children of cast members who are ages 5-10. My tables are...
People (All people who auditioned and their Children)
Cast (Those adults who have been cast for a part)
Children of Cast Members (based on the People Table)
I can't seem to get the relationship right. I've attached the file.
Thanks for your help!