The best way to insert rows into multiple tables?

I can't seem to create a trigger and function
correctly to get it done....

I am trying to create the backend to a web-based
checklist that will insert the data into a db. Once
the chklst_header table is created, I want to create
the child tables with the same currval in the
sequence, preferably on insert into the header table.

Any ideas or examples are greatly appreciated!!!!!

Once I get this all figured out, I would be more than
happy to share the end result of my little project and
the source for others as well.

Thanks.
christian
cpemery [at] YahOO (dot) CoM

__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail