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