1 Reply Latest reply on Aug 16, 2015 9:44 PM by philmodjunk

    Make One to Many Relationship

    Suresh

      Title

      Make One to Many Relationship

      Post

      Dear Admins & Experts,

      I created 3 tables named A, B & C.

      In A, A1 is the primary key.
      In B, B1 is the primary key.
      In C, C1 is the primary key.

      So here, i make relate with table A to B, B to C, but it shows One to one relationship connectivity in Relationship diagram.

      Here I added 3 records for each tables, Actually required A1 has connect with B1, B2... ; B1 has connect with C1, C2...

      Help me to make this relationship as One to Many !!

      Thanks,
      Suresh

        • 1. Re: Make One to Many Relationship
          philmodjunk

          For each Primary key, you need a foreign key field in the related table:

          A---<B----<C

          A::A1 = B::A1Match
          B::B1 = C::B1Match

          A1, B1, C1 should be either number fields that auto-enter a serial number or text fields that auto-enter Get ( UUID ). The foreign key fields, which I've named with "match" as part of the field name here, would be simple data fields of the same data type as the corresponding Primary Key.