one Form to Create Multiple Records???

[1042]

Hi all,

i hope i explain this clearly :), what im trying to acomplish is to have a form that on submision it will create records on different tables, example

form will have

email date
product
region
country - here im going to have some customers assign on by country basis

when the from gets submited the info should go in to a table called latest product offers that will track the date of the email sent, the product sent the region, the country  and a list of customers that the email was sent, so far so good...

the problem im having is that i need to create also tickets (records on a different new table) for each of the customers that the product was sent, the table will have the fields, customer name, product sent and date sent, so if for instance on a certain country i have 5 customers then on submission of the first form i also need to create 5 new records on this second table...

is there a way to acomplish this? i guess i need to do 2 queries? but how do i acomplish this?  thanks to all in advance.