Setting a FK for the PK of the current user
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,