1 Reply Latest reply on Feb 18, 2011 1:15 PM by philmodjunk

    Link two or more records that has one payment

    TaraKopp

      Title

      Link two or more records that has one payment

      Post


      I have a few technical questions to ask in regards to "how-to" using  filemaker Pro 10 Advanced. I work for an art school and we use  filemaker to keep our students database. Now, I've followed your  tutorials and made a simple table but there are a few problems I'd like  to solve.

      1. We (on behalf of the art school) have siblings attending our  school. We create a record for each sibling. However, when we create a  second sibling's record, we'd have to enter all the fields again. We can  duplicate the first sibling's record and edit the fields that are  different from the first sibling but then there is a second problem.

      2. We have a payment field in each record with auto-enter function  so that it balances out. Sometimes a parent makes one payment for  multiple children (2 or more records). We're breaking down one payment  into multiple records, when we would like to have one total per family.

      So in conclusion, we'd like to somehow link all the siblings and  quickly organize the database. Is there a way to somehow link the  siblings records and have one payment field per family, while each  student has a separate record?

      Screen_shot_payment_info_emma.png

        • 1. Re: Link two or more records that has one payment
          philmodjunk

          What tables do you have?

          If you set up these tables/relationships:

          Families-----<Students
               |
               |
               ^
          Payments

          Families::FamilyID = Students::FamilyID
          Families::FamilyID = Payments::FamilyID

          You can enter family data, such as an address once in the family table and just enter student specific data such as name, gender and age in the students table.

          Payments can be linked to Families in much the same way.

          Instead of the individual payment fields like you show in your screen shot, you'd use a portal to Students and another portal to payments on your families layout to list all students in one portal and all payments in the other.