i want to know the proper syntax for selecting multiple table in ADO, say i have 7 tables that i want to retrieve data from using the data i retrieved from the first recordset

i tried something like this

1. i retrieved the data first from empfile

** rsEmpFile.Open "SELECT * FROM empfile WHERE empno = '" & txtempno.text & "'", adoEmpFile,,,adCmdText

2. from the rsEmpFile.Recordset, i will use the data coming from it to retrieve the data from the other tables like this

** if rsEmpFile.Recordcount = 1 then
rsTemp.Open , adoEmpFile,,,adCmdText

...how do i do this? i really need help with it! thanks!

Elinore

**elinore**
---------------------
"The most powerful weapon on earth,
is the human soul on fire" - Ferdinand Foch