How to filter data on Multiple record.

How to filter data on Multiple record.

  
Having a Search Screen. Few fields are searching in parent table and few fields needs to search in child table and return the parent record accordingly.

I have one parent table  it has another child table "Actor" having foreign key of parent table and i want to filter data based on multi select actor Name from the child table .How to achieve this.
 
I Also try Sql tool with
select [ActorName],ParentID from ActorTable Where [ActorName] in  ('+@ActorLst+')
Hi there Hitesh,

I believe you can find the answer to your question here, however it would help when you have such questions that you attach a simple module to help others replicate the issue and provide better and faster help.

Thanks!