I am going to post issues as I run into them, if that is okay.
On my results page I have my recordset defined and I have 1 WHERE clause set (DisplayOnSite = '1').
Can I add another WHERE clause directly in the recordset and not affect the search behavior? I ask because I have a field named Country in the Properties table and in the Area table there is also a Country field which is giving me the response:
Column 'Country' in where clause is ambiguous
How should I define which table column, in the Search Behavior Where clause or in the recordset?