Hi all,
I'm relatively new to MS Access and am experiencing following problem:
I've created following objects & relations:
- Tbl 'EmployeeT' which contains:
Problem: I can't add EmployeeT.EmployeeName twice to a continuous form to show once the name of the TaskOwner and once the name of the person who added the task. I suppose I have to do this by adjusting the SQL code.
Question: How can I get my continuous form to display both the correct Employee name?
Thanks a lot!
I'm relatively new to MS Access and am experiencing following problem:
I've created following objects & relations:
- Tbl 'EmployeeT' which contains:
- EmployeeID (autonumber) = primary key
- EmployeeName (Text)
- TaskOwnerID (Numeric) = foreign key for primary key 'EmployeeID' from Tbl EmployeeT
- TaskAddedByID (Numeric) = foreign key for primary key 'EmployeeID' from Tbl EmployeeT
Problem: I can't add EmployeeT.EmployeeName twice to a continuous form to show once the name of the TaskOwner and once the name of the person who added the task. I suppose I have to do this by adjusting the SQL code.
Question: How can I get my continuous form to display both the correct Employee name?
Thanks a lot!