title: How do i create a Parent surrogate key that corresponds to the Primary surrogate key?
body: <p>I have a table pictured below that has a surrogate Key as the Primary Key, and also two columns that represent a parent child relationship.  Currently, the Primary key is OfficerPeopleID.  The Parent is MgrPeopleID, and the child is PeopleID.<br>
       I want to use the current Primary Key (OfficerPeopleID) as the new child, and create a new field that will be the new parent.  By doing this, the child will now be a primary key, which is my goal.  How do i populate the new parent field to create the same hierarchy structure as the current parent and child fields are doing?
  Thank you!</p>
  
  <p><img src="https://i.stack.imgur.com/7aPpO.png" alt="Dimension"></p>