Hi, I have 2 tables (client, historical)
what I need is, when I add a record in the "historical" table the "client" table is updated, in Master/Detail I have attached the ('client'.'pc_id' = 'historical'.'ph_id')
I do not know how to do it.
// Row Rendered event HISTORICAL TABLE
function Row_Rendered() {
$MyResult = ew_Execute("UPDATE MyTable SET Field1=Value1, Field2=Value2, Field3=Value3 WHERE MyField=XXX");
}
client:
pc_id (primary key)
pc_name
pc_address
pc_phone
pc_concep
pc_importe
pc_file
pc date
historical:
ph_id
ph_concep
ph_importe
ph_file
ph date
Thank you very much.