AnsweredAssumed Answered

Setting a FK for the PK of the current user

Question asked by MikeTrotter_1 on May 24, 2013
Latest reply on May 24, 2013 by MikeTrotter_1

Title

Setting a FK for the PK of the current user

Post

     In my solution, I have tbl_User containing a PK_UserID and a LoginName. The LoginName is created by script at the same time the User is created in Filemaker. Therefore for any currently logged in user, there will be a match in tbl_User. What would be the best way to set the field, FK_UserID to the value of the PK_UserID in the tbl_User based on the currently logged in user?

     Am I going about this all wrong?

     Thanks in advance,

      

     Mike

      

Relationship.jpg

Outcomes