2 Replies Latest reply on Jun 16, 2013 5:20 PM by skearton@cygnusgroup.ca

    lookup question

    skearton@cygnusgroup.ca

      Title

      lookup question

      Post

           Hi,

           I have a table called z_Resources with a global field called g_AccountName that captures the current account name of the employee logged in. It is a calculation field using Get (AccountName). I would like to lookup the related ID for that that Employee in the Employee table  to use in other areas of the database while they are logged in. I have a relationship between the two tables that uses the g_AccountName to the Employee Full Name as match fields.

           I'm using a global field in the z_Resources table called g_EmployeeID that does a lookup for the Employee ID based on the match of AccountName to Employee Full Name.

           It is not pulling in the Employee ID when the g_AccountName is filled in.

           Could someone tell me what I'm doing wrong?

           Thanks so much for your help!