Filter One Recordset with a Different Recordset
Building a blog with PowerCMS.
I have added a search box that searches the contents table where the ContentRefID is Content; however in the Results Page I want to display the Blog Titles for that ContentRefID.
I have set up to separate recordsets (one for Titles and One for Content), and the Title and Content for a post share the same ContentPageSetRecord value. I need to pull from the Title recordset based on the ContentPageSetRecord value from the Content recordset.
How do I filter the Title recordset? The Content recordset is created first.