Thanks for the detailed explanation of the issue. It helps a lot when we don't have to guess about different features of your system.
You need two separate relationships. One for the current manager and one for the second.
You want your relationships graph to look like this:
Manager::Manager ID ----= ----Contracts::Manager ID
Contracts::Manager ID----=----Manager 2:: Previous Manager ID
Note that Manager and Manager 2 are two "instances" of the same actual table.
You don't actually need your Manager Name and Previous Manager Name fields.
Instead, place the fields Manager::Manager Name every where you need the current manager name and Manager 2::Manager Name everywhere you need the previous manager's name.
That break down the barriers for you? :smileywink:
Yes. :smileyhappy: Thanks much.