I want to open a three tables and maybe as many as 5 tables at one time..using data from one table to pull certain records from a second table and then pull data from a third table base on data from the second table.<BR><BR>Here is the code I have been using<BR>***************************************** *****************<BR>sql_search = "select PeepsID from CategoryLink Where PeepsID Like&#039;%" & SearchID & "%&#039; Order by CatName "<BR><BR>Const adCmdTableDirect = &H0200 <BR>Const adLockReadOnly = 1 <BR>Const adOpenStatic = 1 <BR>Const adUseClient = 3<BR><BR>data_source = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("contacts.mdb")<BR><BR>Set con = CreateObject("ADODB.Recordset")<BR><BR>con.CursorL ocation = adUseClient<BR><BR>con.Open sql_search, data_source, adOpenDynamic, adLockReadOnly, adCmdTableDirect<BR><BR>************************** *************<BR>this code opens one table fine.. How would I go about opening a second and third table?