I have a table called EmployeeIDS. In the table there is a Client manager field which consists of numbers (I join this field to the Client Mgr field in the main table). I also have a field called ASM which consists of numbers which I join to the main table by the field ASM. In the EMployeeIDS table I have a field for employee Ids so that field is populated for both the Client manager and the ASM. When I join the EmployeeID table to the Main table by Client Manger and then by ASM, I bring the EmployeeId field into the query. In the query, I have [forms]![Rep/asm input]![txtRepNo] or [forms]![Rep/asm input]![txtRepNo] is null and
[forms]![Rep/asm input]![txtASMpNo] or [forms]![Rep/asm input]![txtASMpNo]is Null.
I also have [forms]![Rep/asm input]![txtempid] for the EmployeeID field.
On the form that is connected to this query (Rep/asm inpup), I want them to be able to enter in one or the other – Client Manager or Asm but always have to put in the employee id.
It is not working like I think it should. I thought maybe my employeeID table was setup wrong. I am using one column for the Employee Id which is for both the ASM and The Client manager. I am not sure what I am doing wrong. I have attached a picture of my query.
