1 Reply Latest reply on May 17, 2010 6:37 AM by mrvodka

    Help with Parent and Child Tables

    Fxguy

      Title

      Help with Parent and Child Tables

      Post

      I am trying to create a Check In Database for our Children's Ministry. Forgive me for forgetting much of my database training that was in Access. What I've done is set up two tables, a parent table and a child table.  On the Child Form I want to sent up a portal that lists the parents allowed to drop off each child. The problem is that each child will have multiple parents allowed to drop off (Assuming a mom, dad, guardian style relationship) and a parent can have multiple children. I set up a ChildID field in both tables, which I can get to link the first record, but that is all. I'm so lost! In access terms it would be a many-to-many relationship. Any thoughts on how I can have the first and last name for each parent appear on the corresponding childs form?

       

       

      Thanks!

      Tim