I have a form that is created from multiple queries. In the form specific relationships, I have two tables, Events and Registration. I also have a query SupervisorName.
They contain the following pertinent fields:
Events
EmployeeID
Registration
EmployeeID
SupervisorName (Query)
EmployeeID (From Registration Table)
FirstName (From Employees Table)
LastName (From Employees Table)
This started with just the first two tables and only the reference number would appear in regards to EmployeeID. I need to have the actual name showing in that field, so I added the query that links to the FirstName and LastName fields. The EmployeeID field also appears on the Employees table.
If I just try to add the Employees table to the query for this form, I get a joint expression not allowed error, hence the query.
With the query I currently have in place
Registration![EmployeeID], SupervisorName![LastName] & ", " & SupervisorName![FirstName]
I get a #Name? error when viewing the form. I've looked through all the help files I can find, but have had no luck in creating a working expression. All I need is for it reference the EmployeeID that is linked to the particular item (in this case it's for a class registration through the Registration table/form) and for that reference to be converted to the LastName, FirstName standard via the Employees table.
Thank you in advance for your help!
They contain the following pertinent fields:
Events
EmployeeID
Registration
EmployeeID
SupervisorName (Query)
EmployeeID (From Registration Table)
FirstName (From Employees Table)
LastName (From Employees Table)
This started with just the first two tables and only the reference number would appear in regards to EmployeeID. I need to have the actual name showing in that field, so I added the query that links to the FirstName and LastName fields. The EmployeeID field also appears on the Employees table.
If I just try to add the Employees table to the query for this form, I get a joint expression not allowed error, hence the query.
With the query I currently have in place
Registration![EmployeeID], SupervisorName![LastName] & ", " & SupervisorName![FirstName]
I get a #Name? error when viewing the form. I've looked through all the help files I can find, but have had no luck in creating a working expression. All I need is for it reference the EmployeeID that is linked to the particular item (in this case it's for a class registration through the Registration table/form) and for that reference to be converted to the LastName, FirstName standard via the Employees table.
Thank you in advance for your help!