Compare the Rows of Two Tables in plugin

[crmdev]

hello i want to write a plug in which will compare the sales_id(it is an attribute on SalesHistory Table) and sales_id(which is attribute on Account Table)

if they are equal i want to set sales_id(it is on account table) to account_id (it is om saleshistory table ).

here is my question i have tried to get values by using retrieve crm method but it didnt success to work this job.

how can i perform this task ?

thanks

[andopes]

You can do that in a before_save logic hook.

Cheers