M
Michaelcip
I have a table w/ many fields incl. an employee's name & his manager. As an
employee, the manager will have his own record which includes HIS manager.
I need to make-table, using the "Operator" & "Manager" fields. There are
some cases where the Manager acts as the operator, so I want to take that
into acct. when I make the table & have HIM acknowledged as the
manager,...not HIS mgr. My query of need: If "Operator" is a manager, then
append into the field "Operator" (the mgr's name), otherwise append
"Manager". Since managers have managers, it's appending the mgr's manager.
Many thanks,
employee, the manager will have his own record which includes HIS manager.
I need to make-table, using the "Operator" & "Manager" fields. There are
some cases where the Manager acts as the operator, so I want to take that
into acct. when I make the table & have HIM acknowledged as the
manager,...not HIS mgr. My query of need: If "Operator" is a manager, then
append into the field "Operator" (the mgr's name), otherwise append
"Manager". Since managers have managers, it's appending the mgr's manager.
Many thanks,