Writing Data To Multiple Tables (Howto)

Can someone show me the command string required to write data out to 2 or 3 tables at once?  How about how to write 2 entries at once?  Write now my solution writes 1 record to a table and then I write somewhere around 40-200 records to a second child .  Write now I'm writing like this:
Open --> Add 1 record in table #1 --> close
Open --> Add 1 record in table #2 --> close
Open --> Add 1 record in table #2 --> close
Open --> Add 1 record in table #2 --> close
Open --> Add 1 record in table #2 --> close

and I'm just wondering if there is a better approach, such as writing all the data at once.  Something like:
Open --> Add 1 record in table #1 --> Add 5 records in table #2 --> close