CiviCRM Community Forums (archive)

update. I don't know if this the best way to do it. am sure there must be some safer way, what i did is insert this in hook form_postprocess

        $current_employer = CRM_Core_DAO::getFieldValue("CRM_Contact_DAO_Contact",
         $contactid, "employer_id");
         
   $query = "UPDATE civicrm_relationship
   SET is_active=FALSE WHERE contact_id_a={$contactid} AND contact_id_b!={$current_employer}; ";

   $dao = CRM_Core_DAO::executeQuery($query);