1 Reply Latest reply on Apr 18, 2010 1:45 PM by davidanders

    Understanding Relationships

    Axxiom01

      Title

      Understanding Relationships

      Post

      Greetings,

       

           I am in desperate need of some help in understanding how relationships are drawn properly in FileMakerPro 10. I have been getting training from a friend on database development using FileMakerPro10. We were 3 months into a practice project before my teacher finally understood that I was not comprehending how relationships we're formed and how to properly draw them in the relationships table. I will give a short example as to a very simple address database we were trying just to help me understand the very basics (unfortunately I'm just not grasping it). I started by creating 4 tables and naming them...Individuals/Households/Phones/Email. As a basic rule each table contained its own signature ID as a field followed by any other data I wanted displayed.

          [Individuals]     [Households]     [Phones]                 [Email]

          id_ind               id_hh                    id_pho                     id_ema

          name.first        hh.name              phone.name          email.name

          name.last.       address1             phone.type             email.address

          D.O.B.               address2             phone.10digit

          name.prefix     street

          name.suffix      city

                                     state

                                     zip5

                                     zip4

       

      Knowing that to form or be able to draw a relationship from one table to another it must contain a "related" data field. So which ID fields belong in which tables and why? Do ALL tables need to have every signature ID in them to work properly? Why would phones need "id_ema" or vise versa. I'm not even sure that I'm trying to ask my question properly but if anyone could please help me to understand this basic fundamental of database programming or perhaps point me to some literature to help my comprehension (Where is database programming for Dummies when I need it) I would be eternally grateful. My teacher is becoming very frustrated that I am not grasping this and I don't want to let him down as he a great person and mentor to me,...and I'm beginning to feel very inadequate and that this may beyond my powers of reasoning. Thank you to anyone that can possibly shed some light on this for me. TY TY TY

        • 1. Re: Understanding Relationships
          davidanders

          If you have three piles of 3x5 cards

          PeoplePile with info

          AddressPile with info (because People may have one or more addresses)

          PhonePile with info (because People may have one or more phone numbers)

           

          People has PeopleID which is unique within People

          Address has PeopleAddID which is NOT unique to all Addresses (there may be two or more)

          Phone has PeoplePhID which is NOT unique to all Phones (there may be two or more)

           

          PeopleID relates to PeopleAddID (shows addresses for People)

          PeopleID relates to PeoplePhID (shows phones for People)

           

          White Paper for FMP Novices