6 Replies Latest reply on Jun 15, 2015 8:10 AM by GuyStevens

    Relate Get(AccountName) to StaffID records

    Stu412

      Title

      Relate Get(AccountName) to StaffID records

      Post

      Hi there

      I have a staff table on my DB which is related to many other tables and works well for job planning etc.  All the relationships are done via a primary key StaffID.

      I am working now for the first time in a server environment and want to track through the system (as well as the server) who is logged in.  This will also help me with a homepage I want to direct certain staff to (ie, if a staff member is a manager they go to a different homepage.  The manager role is defined on the staff table).  I also want to refer to staff throughout the system by first name only, rather than their full logged in credentials.

      How can I relate Get(AccountName) to staff records?  There's no ID in Get(AccountName).

      Thanks in advance