problem where 1 recordset's values must equal another

<i><b>Originally posted by : hannelie (sg18@hotmail.com)</b></i><br />okay - little bit too complicated for me and I have been pulling out my hair for the past 2 days.<br /><br />I have 2 recordsets - one called Recordset1 and the other ContentRecordset.<br /><br />Recordset1 contains 2 fields - ID and Contentlist<br />Contentlist consists of a list of numbers that are separated with the delimiter ",". What I do, is read in the Contentlist, and Split them into the array arrContent(). <br /><br />Now, ContentRecordset contains 2 fields as well. ContentID and Name.<br /><br />I need to print a list, of all the records in ContentRecordset where the contentID = arrContent(x) for all the numbers in the array.<br /><br />I have no idea where to start with this - if I should use SQL, an embedded for statement or an If statement or a repeat. <br /><br />Any help will be gratefully appreciated.<br /><br />h.<br /><br />