AnsweredAssumed Answered

Foreign Key

Question asked by AdamRoberts on May 4, 2014
Latest reply on May 6, 2014 by AdamRoberts

Title

Foreign Key

Post

     I have just starting using filemaker so please be patient with this very basic question. 

     I have two tables, Clients (with a ClientPrimaryKey) and Programs (with a ClientForeignKey) . I am having issues populating the "ClientForeignKey". Is there a way that when I add a new client "name" in the Program Table, that the foreign key in that table can automatically populate with the ClientPrimaryKey from the Clients table, The field "Name" exists in both 

      

     Any advice I would be most grateful 

      

Outcomes