Hi,
My DB structure is like that I have a class table and a class_trainer table. In class_trainer table I store class_id and trainer_id as which trainer are going to take the class. One class can have multiple trainers. To build my tabular report I could not crate a view with class and class_trainer table. Because, it shows duplicate row for a single class. So I build that report by only class table and trainer list I am show by a calculated field. But I need now a filtering field for trainer search in my search form How can I achieve that. I have added a virtual field but obviously it