Submitting data to multiple tables in a SQL Server database

[peghall]

I have a form that should submit data to two seperate tables that have a
single relationship.
The main table holds customer information and the second holds information
concerning events pertaining to the customer.
The second table should be able to receive mutliple records and the data
should be submitted to both tables when the form is submitted.

Any thoughts in how to do this?

 

[Greg Collins]

You might want to take a look at Qdabra Software's DBXL product which makes
submitting data to databases very easy.