How to insert data in multiple (related) tables

[anjelika]

Hey,
I know that inner joins can be used to retreive data from multiple related tables, but how can I insert data in multiple tables?
Currenty I am using more SQL queries in order to do that (inserting data in one table, then reading the ID of the primary key in order to use it as a foreign key in another table, etc...), but I think there should be an easier way to do it.
I am open to suggestions and the right way to do it.
Thanks for your time!

[rmiao]

May use trigger.

[anjelika]

Thanks for the reply, but what if the DBMS does not support triggers (e.g. Microsoft Access) ?
Any ideas?

[rmiao]

Then you have to handle it in frontend app.

[anjelika]

Thanks, that was I "affraid" of