Update a value in field based on matching field in different record

[mtatum]

Hello,

I have the following scenario.  I have an employee table as below.  What tool(s) could I use to achieve the desired result? 

Thanks in advance for your help!

Mary 

[AngelosPachis · Accepted solution]

Hi @mtatum ,

A Find & Replace tool would work like a charm here. Just make sure that you convert your Emp and Mgr # fields to a string first via a select tool

Regards,

Angelos

[mtatum]

Thank you so much!  You are right....like a charm!