Thanks Ray, But I am unfamiliar with the Data Search Feature, consequently I am unsure what to do with this. can you give me some pointers as how I would adjust what I already have to achieve this. I have had a quick play with it by removing the parameters and adjusting the SQL so the results are built on the relational value of 'members_id' from the two tables, which returns all results. But when adding a 'Data Search' server behaviour I am not sure what filter settings I need to use and how I would build the form that selects the options to filter the results.
Thanks in advance.