I have a customer requirement that basically says, swap data between 2 fields on the Project properties view. Upon analysis it appears that a data swap between database tables is necessary to satisy the requirement.
One of the field is 'manager' that maps to inv_investments.manager_id while the other is a custom field that maps to odf_ca_project.managername.
I believe there are more than one ways to acheive this, but i think a sql update will be the quickest.
I think updating the custom field() should be safe enough.
What i am worried about is updating inv_investments table. I am thinking that if i can find all relationships that this column participates in, then it's just a case of
updating the value in those related tables.