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!