You cant do this with a separate recordset, it must be done using an inner join.
perhaps some screen shots will help me see the problem.
Can you send screen shots of the item recordset you created, the inner join recordset and the error message?
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.