Insert records from user form to multiple tables in same database

Thanks Walt. This is what I have so far. Do you know if I can combine the

2 commands into 1? Also could you explain to me how to redirect the user after the information has been submitted?

****

<%
set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_Call_access_STRING
Command1.CommandText = "INSERT INTO tbl_Rd1_A1 (Ans1)  VALUES ('" + Replace(Command1__var1, "'", "''") + "') "
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()
%>
<%
set Command2 = Server.CreateObject("ADODB.Command")
Command2.ActiveConnection = MM_Call_access_STRING
Command2.CommandText = "INSERT INTO tbl_Rd1_A2 (Ans2)  VALUES ('" + Replace(Command2__var2, "'", "''") + "') "
Command2.CommandType = 1
Command2.CommandTimeout = 0
Command2.Prepared = true
Command2.Execute()
%>

******

I truly aprreciate your help in this

Thanks guys, I don't know much PHP so I waas hoping to use ASP with an access database.

To be a bit more specific, it would look like this logically.

Insert into table A values for table A fields from form

Insert into table B values for table B fields from form

Insert into table C values for table C fields from form

If you are using transactions, highly recommended, surround the three statements with a start transaction and end transaction.  That way, if any one of the inserts fail, the database will remain in a coherent state because all will fail. 

Walt

B & B Photography

Regardless of the query language, the answer is yes.  You need to create separate insert queries for each table value group in the server side code that responds to the submit on the web from.

Walter

B & B Photography

I'd offer a solution but you didn't mention your query language so I don't want to waste time providing an example that you may not need. Lesson: mention your scripting and query language in your post if you want someone to provide you with an example.