2 Replies Latest reply on Jul 10, 2015 8:51 AM by mariaocheltree

    foreign key

    mariaocheltree

      I type the foreign key each time that I enter a record in my layout. In access the foreign key is set automatically when I used a sub form. Does FileMaker has something similar?

        • 1. Re: foreign key
          beverly

          It relies on relationship and context. If you have a relationship (parent::primaryKey = child::foreignKey), AND allow creation to records (in child) based on this relationship you are nearly there. Go to the parent record, put a portal on the layout based on the relationship. You should see a blank line as the last row on the portal. If you enter values in the new row, the foreignKey *will* be auto entered.

           

          -- sent from myPhone --

          Beverly Voth

          --

          • 2. Re: foreign key
            mariaocheltree

            Thank you,

             

            It works.