AnsweredAssumed Answered

Foreign Key

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


Foreign Key


     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