I got the problem to insert record into three table concurrently. Let me 
tell the detail about my problem. I have two table which are Friends and 
IP_Provider. These two table got many-to-many relationship. So, I created 
another table call IP_Friends. For your information, I'm used Access 
database and I was created the query also in Access database that I call 
qry_IP_Friends. 

I can insert record thru this query (qry_IP_Friends) in Access database 
and display it into the web browser using JOIN statement. But I dont know 
how to insert the record from web browser into the database as you know 
these table got relationship to each other. The other way to display 
record into browser via using query parameter. For example:-
.
.
(assume connection astablished already)
sql = "query name"
Set rs = conn.Execute(sql)

Then use rs to cycle thru the recordset to display the data. With this 
idea, can we use the query name to insert the data from browsert into 
database? I need to insert all the record into these table because this 
page is for Administrator which they can insert new record, delete, 
display and search to the record.

I hope some body can help me as I was asked this question to many forum 
like this but nobody response me.

I help is much appreciated.

Thanks.

Hazh