Hello all!
I have an application in VB6.0 which connects to MS Access database table. I am able to search for a record and display results in a VB forms' texboxes. But now the problem I am having is that, I have 2 tables joined together by primary keys i.e. Table1 and table2. Table1 is the parent and table2 is dependent on table1. the relationship is 1 to many (table1->table2). I want in my vb form to search for a particular record and then display th contents of both table1 and table2 in one form.
How do I write a query that will do that. For one table, I am able to do that
e.g.

dim dbs as new adodb.connection
dim rst as new adodb.recordset

set rst = new adodb.recordset

search = msgbox("Input search item")

rst.open "select * from table1",dbs,1,2
rst.find id='"+ search +"'"

That is the code above will work for 1 table. but now that I want for the second table, how do i do it..

Thnak you