Hi,
Modifying the
insert query should allow you to change the way how and what is stored, however, it's not possible to run two insert queries as one. One of the typical problems would be how to obtain the correct ID for the relation - to be referenced in other table.
I think that better approach to achieve your aim would be to use a
custom global event handler, which would store the relation record after an Insert (or Update) event happens (= OnAfter-..) for the custom table.
Please see more details how to achieve it at
devnet.kentico.com/docs/6_0/devguide/event_handlers_overview.htmRegards,
Zdenek