Issue in join datasource for form


I’m trying to filter the record based on checkbo, when I check the form is filtering the records correctly but when I add a new ds to the form and gave relation to this table the checkbox isn’t filtering the form.

I used BOMVersion table and BOMTable, i gave relation for BOMVersion to BOMTable with inner join.

How can I specify my queryrange now?

Can you give us more details, please? For example, how are you setting the range and what query is sent to database in the “broken” case?