Add to another table on insert ?

shawnlc · Post by **shawnlc** » Mon Jan 16, 2017 2:34 am

Is it possible to add to another table on insert (insert on table A (field1, field2, field3, field4, field5), also add to Table B (field2, field4, field5))?

mobhar · Post by **mobhar** » Mon Jan 16, 2017 10:10 am

Yes. Just use "Row_Inserted" server event to execute INSERT INTO SQL to table B (use ew_Execute global function to execute that SQL).

Please read "Server Events and Client Scripts" topic and "Some Global Functions" sub-topic at the bottom of that current manual page from PHPMaker Help menu for more information.

shawnlc · Post by **shawnlc** » Mon Jan 16, 2017 6:17 pm

Thank you.