2 table,different field,save data in table A&b at same time

Suite and Optimus Suite 5
#1

Hi ,

I had 2 table table A and table B, it have different field.

table A
awayid, awaydate,name,reason,officetime

table B
slid, applicant, sl_date, sl_time, approval, appendix

When I input the data by dhtmlxForm, it can save the data into table A and table B at the same time.
such as :
tableA.name = “john” tableB.applicant = “john”

tableA.reason = “sick leave” tableB.appendix = “sick leave”

Could you give me the suggestion and how to do it.
Thank you.

#2

While connector can load data from multiple tables ( render_sql with inner join ) it can’t save data to two tables.

You can attach custom sql or custom php code to saving action to define any custom behavior.

docs.dhtmlx.com/doku.php?id=dhtm … ex_updates