I have an access database that i have gracefully been deemed responsible for.. I for the life of me cannot figure out how to do this simple relationship scenario..
id - PKey Auto Inc job_number employee_id - Text -> links to UserInfo Linked SharePoint List Table call_description
User Info Linked SharePoint Table
This table is readonly, a linked table from a SharePoint list..
id - PKey Auto Inc employee_id Name - Full name of employee
On the input form the call center tech will fill the form out, and enter the employee's ID number. Once they enter that i want it to show the employees name from the
[UserInfo].[Name] column in a textbox..
I tried using a
DLookup function like so:
=DLookUp("[Name]","[UserInfo]"," [UserInfo]![Employee ID] =" & [Forms]![Call Entry]![employee_number])
but all i'm getting is #Error. the form's data source is set to the Call Table.