Column 'county' in where clause is ambiguous - error when adding 'DataAssist Search Behaviour'
I a trying to manually add a 'DataAssist Search Behaviour' to a page but I am getting this error when I have added it.
'Column 'county' in where clause is ambiguous'
I am hoping to eventually have 3 filter options which will be - "View By - 'county' , 'agent' and 'All'.
But for now I just want to get the first filter working form the 'county' column in the recordset.
Page attached... Thanks in advance.