How can I enter data into 3 separate tables in my database using a single form?

Applications Forms
, ,
#1

I have 3 tables in the database and I want to register these tables through a single form. How can I do that?

#2

Hi, same data? the only way is on after insert by code,

sc_exec_sql ("insert into table2…, “Conection”);
sc_exec_sql ("insert into table3…, “Conection”);

and onAfterUpdate

Regards

2 Likes
#3

Thank You so much. I will try it.

#4

Hi another way, if you use Mysql for example, you could create store procedures with triggers but this is more complex.

I’m curious. Why do you replicate the same data in 3 tables?

Regards.