CMS Builder has a multisearch function that sounds ideal for this. It allows you to search across multiple sections, and select which fields you wish to search in each section.
This post has some example code attached to it that should get you started:
and this post explains some of the options you can use in it:
Let me know if you have any questions.
PHP Programmer - interactivetools.com