dear friends,

i m using a database of two tables related wid each other by one to many relationship. i want to save and retrieve da data from dese two tables. e.g

t1 is table whose primary key is working as foriegn key in t2 table.
primary key is NIC. on the basis of dis field i want to save da data in table t2, and also want to retrieve it in the similar fashion.

but i dont know wat will be the right query to save and retrieve da data, i am using ADO and access database.
please solve the problem thnq

What do you mean you want to "save the data in table 2?"
You want to insert data into table 2?
If that is the case, you can, with a recordset, use the .Add method, then set each field to the value for the new record, setting the field that erlates back to table 1 to the value for NIC of the record you want to relate to.

dear friend, i could not understand it, i want to store da data in the both table using one query under save button and retrieve as well from both tables using one query. plz tell me right query

thanq in advance