DA Search and Recordsets with Joins
I have applied DA search to a page, it doesn't seem to work properly. I have used it on other pages and have not had any problems but for some reason it doesn't work as expected in this instance. The only difference I can see looking at the generated code is that the recordset has a join in it. Here is the SQL:
SELECT DISTINCT tblinspectors.fldInspID, tblinspectors.fldInspNum, tblinspectors.fldFirstName, tblinspectors.fldLastName, tblinspectors.fldTradNam, tblinspectors.fldSuburb, tblinspectors.fldState, tbltransactions.fldProcess
FROM (tblinspectors INNER JOIN tbltransactions ON tbltransactions.fldInspNum=tblinspectors.fldInspNum)
I have attached the source in a zip to this post.