Search field is not filtering to Measurer Last Name

I double clicked the search behaviour and compared the Hunters Last Name to the Measurers last name but when I type something in measurer last name it is like nothing is entered. All records are returned. The hunters last name works correctly.

whitetaildeer_Results.php?S_DClass=&S_DMethod=&S_DScore=&S_DPoints=&S_DPoints2=&S_DCountyOfKill=&S_DYearOfKill=&S_DYearOfKill2=&S_DHunterLast=&DMeasurerLast=z&Search.x=34&Search.y=10&Search=Search

In the results page you posted it looks like you are using AND as the separator. I think you should be using OR to get a more inclusive result set. To check out the searching functionality for these two name fields try either editing the existing page or creating another that does only those two searches. Start with the just the measurer and ensure that that works, when it does add in the other criteria for the hunter. Both of these should be like comparisons and the separator should be OR.

Please give this a try and let us know what you get, also without a login I was unable to test this advanced functionality of the search.

Hunters Name was and is working, Measurer is not. I tried the or but that did not work.
Please use the user and pw of waTest to be able to test the search. When you type something in the measurer you get all of the results returned which makes me think that the value typed in is NOT hitting the database. Thanks!
whitetaildeer_Results.php

It looks as though the search is configured correctly for both the hunter and measurer so I'm not sure why this result is occurring. In my previous post I was asking you to perform a test to limit the search criteria to only measurer and hunter. You should try to get the measurer part working first before adding in the hunter. If you cannot get a search that is only looking for the measurer working on it's own then it is not likely that you will be able to get it working in combination with the other search criteria. Please run through this test for measurer and let us know what your result is.

Te form field was labeled incorrectly. Sorry for the trouble! All the rest of the fields started with S_ and this one was labeled that way but should not have been to bind correctly.