mass update question

[tj@estreet.com]

Hey All,
I have a custom field 'mao' in both Contacts and Accounts that is updated via Accounts mass update.
I'm trying to set the contacts mao to equal the Accounts mao on update and thought the following function would do the trick, but I can't figure out where to put it (Accounts.php? Contacts.php? ListView.php?)

 function conatctsMAO(){
    $update_mao =" UPDATE accounts,contacts,accounts_contacts SET contacts.mao = accounts.mao WHERE accounts.id = accounts_contacts.account_id AND contacts.id = accounts_contacts.contact_id ";          
    $db = & PearDatabase::getInstance();  
    $result = $db->query($update_mao);  
} 
  

Any thoughts?

[simple]

Hi

In Accounts.php ...adding (overriding) the save method?

class Accounts()  extends SugarBean {

...

   function save($check_notify = FALSE) {
      parent::save($check_notify);

      $this->conatctsMAO;
   }

}

Just an idea...

[tj@estreet.com]

Hey Pascal,
Don't mean to appear ungrateful. I've been tied up with a nasty synchronization issue and haven't had a chance to try your suggestion. Will let you know. Thanks for the input!