Forum Discussion
Adding managers as employee in employee table
I have employee table as below , in which managers name is not there as employee itself. hence am not able to get path(). how can i add managers name in same table as an employee
ID | Name | Manager | Dept |
1 | Morris Garcia | Adam Sampa | Sales |
2 | Jessica Smith | Ravi Shankar | Purchase |
3 | Thompson Crawford | James Goodwill | IT |
4 | Steve Pepple | Adam Sampa | Sales |
5 | Erica Jones | James Goodwill | IT |
6 | Sheila Stones | Ravi Shankar | Purchase |
7 | Jimmy Grey | Alisha Cordwell | Finance |
8 | Abigail Thompson | Adam Sampa | Sales |
9 | Stella Given | Alisha Cordwell | Finance |
10 | Anne Wu | Ravi Shankar | Purchase |
Hi muhch ,
You can use Append Queries.
Here're the steps.
1.Duplicate the table.
2.Remove the ID and the Name columns, rename the Manager column as Name.
3.Remove duplicates.
4.In the main table, append with the second table.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi muhch ,
You can use Append Queries.
Here're the steps.
1.Duplicate the table.
2.Remove the ID and the Name columns, rename the Manager column as Name.
3.Remove duplicates.
4.In the main table, append with the second table.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
there is no ID for managers here..as saif managers name has no entry so far in employee table
