Helllo Sir, I have two tables, Office and City. When I make search the Office with city locations, it is not working. In Example, the filter statement (Office.Office_Name like "%" + Search + "%") is OK. But (Office.Office_City like "%"+ Search +"%") gives me an error--- "Cannot apply 'like' Operator to 'CIty Identifier' together with 'Text'. Any Solutions to correct it? Thanks in advance.



Hi Zaw Thet,


Office_City holds the id of the city, not the name.  You will have to add city as a source to your aggregate, and then add filter on City.Name.


See for example attached oml.


See this video for an explanation about multipe sources and joins.


Good luck,

Dorine