AnsweredAssumed Answered

Relate Get(AccountName) to StaffID records

Question asked by Stu412 on Jun 15, 2015
Latest reply on Jun 15, 2015 by GuyStevens

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

Outcomes