Untuk sementara, hanya dapat dilakukan via SQL, berikut contoh nya : 

SELECT tsh.cnofaktur, tsh.ckode_customer, tsd.ckode_produk, tsd.nprice FROM  tbl_sales_h_pabrik tsh LEFT JOIN tbl_sales_d_pabrik tsd ON(tsh.cnofaktur=tsd.cnofaktur) WHERE tsh.ckode_customer='B20SUM00001' AND tsh.dtanggal between '2014-04-01' and '2014-04-30' AND tsd.ckode_produk='1401001';

CREATE TABLE tmp SELECT tsd.id, tsd.nprice FROM  tbl_sales_h_pabrik tsh LEFT JOIN tbl_sales_d_pabrik tsd ON(tsh.cnofaktur=tsd.cnofaktur) WHERE tsh.ckode_customer='B20SUM00001' AND tsh.dtanggal between '2014-04-01' and '2014-04-30' AND tsd.ckode_produk='1401001';

update tbl_sales_d_pabrik set tbl_sales_d_pabrik.nprice=5000 where id in (select id from tmp);