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