Hi,

I have a database among 6 tables. Each record goes from the main table to 5
other tables via 1:1 relation. A new record is only inserted once in the
main table tblPERSN, and the primary key ID_PERSN should become inserted in
the 5 other tables as a foreign key (ID_PERSI, ...).
What trigger is right? Insert in tblPERSN must be followed by an insert in
tblPERSI.
I think it should look something like that?

AFTER
INSERT OF ID_PERSN ON myuser.tblPERSN
NEW AS ID_PERSN
BEGIN
Insert into tblPERSI
Values (ID_PERSI := new.ID_PERSN,,,,,,);
(... entry for each table)
END;

Is the trigger right on tblPERSI or does it belong to tblPERSN?

thanks