AnsweredAssumed Answered

How to populate New Record

Question asked by annata on Aug 3, 2017
Latest reply on Aug 3, 2017 by philmodjunk

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?