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!