I have two related tables Consultants and Clients. The Client table has a field Consultantfk that relates to the Consultant tableID
A consultant logs in on FileMaker Go to a Dashboard layout with a Client button.
The Client button opens a Client layout where the available client records have been filtered using privilege set security and this is all working fine.
However when the New Record Button is clicked a blank record is opened without any consultant info on it . If I manually put the Consultant ID number into the Consultantfk field it populates with the Consultant name etc. How can I have this happen automatically?