Hey y'all.. need some definite help here. I have two tables, one for Parents, and one for Children. There may be multiple Children for any given Parent, and they're both related in their tables via a unique FamilyID. I need to pull each Parent record, and ALL related Children records into a recordset. Ex. Parent Bill has two kids, Jimmy & Tommy.
Parent Dave has one kid, Molly. I need to retrieve a recordset that looks like this:
Bill, Jimmy, Tommy
Dave, Molly
Obviously, one of the challenges is that the different number of Children that will be output - though I'm fine with retrieving multiple children info into a single column. Suggestions?