AnsweredAssumed Answered

lookup question

Question asked by on Jun 13, 2013
Latest reply on Jun 16, 2013 by


lookup question



     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!