I have a simple recordset that returns rows of data from a table. I need to take one of the fields from each row returned [memberid], and perform another query and show text if that 2nd recordset is not empty.

For example my 1st recordset shows 5 rows of data for 5 different members. If a particular memberid is not in a particular table, I want to hide text on that row of returned data. If memberid is in a particular table, I want to show some text for that row of data.

I tried creating two recordsets, but that doesn't work. How can I do this?

Huh?

Edited by - seekingfun32 on 05 Sep 2003 22:49:01

What if you change the SQL for that record set so it returns all the information froom all the table you want using that memberid. Basically, join more table together which should meand that u dont need to make another recordset for the extra data.?? I hope this makes sense