4 Replies Latest reply on Jan 3, 2016 6:45 PM by sharton

    Automatically populate a foreign key field with a related table's primary key field

    sharton

      Hello,

      I am very new to FileMaker, and am creating my new database. I took the "Basics" course, and am now creating my first solution from scratch. Most importantly, I want to ensure my tables and relationships are setup appropriately. My issue right now is that I have created a one-to-many relationship between 2 tables (Accounts and Contacts); and cannot seem to get the foreign key field in the Contacts table to populate with the primary key field from the Accounts table. In this specific case... I am trying to do the following:

       

      • When I create a new Contact, and then select which Account the said contact belongs to (from a Value List on the Account field), I simply want that Contact to be linked to that Account. This way, when I view a specific Account, I can see all the Contacts tied to this Account via a portal. I currently have an Account Table with only 3 records (1 for each account, each with a unique ID), and then a Contact list with about 20 records where I'd like each contact to be tied to one of those 3 Accounts. Does this make sense? Maybe I am over complicating it?

       

      Thank you a great deal for any help in advance, there is no question FileMaker is a program with limitless functionality, the light bulb just hasn't turned on yet!

       

      Steve