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