Automatically creating records in sub tables

[nsl]

I have a main table and three sub tables, all three sub tables are linked to the main table by a unique id.

When the user creates a new record in the main table I want to automatically create a new record in each of the three sub tables that link to the new record in the main table.

Can I automate this process?

[PeterHW]

I would suggest you script the creation of the record in the main table, and in the same script create the new records in the related tables. This would require the push of a button by the user, but there is no way to 'automatically' create child records upon creation of parent records.

Regards,

Peter