>I'm also using an SQL Server backend, what I'm doing whenever I get multiple matches is pull them all (with a predefined limit), and the user can navigate through them with a standard navigation toolbar or a list. As far as the search form goes, I liked Nadya's idea of having a "type of search", I don't remember if she meant within the search form (an option group maybe) or another form before the actual search form, I like the first method.
In our case (BTW, just plain VFP tables) pressing Search button invokes a form with several Search Type options, then the correct search form is displayed. The advantages of this method are that you can easily add new type of search later.
Of course, the single search form (may be with two tabless pages) could be used as well. E.g. first tab will represent options with types of search and then the second tab would be activated (or appropriate tab) with the necessary search details... Yes, sounds like a plan... :)
If it's not broken, fix it until it is.
My Blog