Hi @Kerian ! As you are new to the community, when you get a chance, please introduce yourself here. I’d also encourage you to add a real picture as your avatar because it helps build community!
It looks like your query is based on household_id. I would recommend checking that id is recorded correctly in the household_census (you can check this in tables on the tablet) as an initial debugging step, in case there is a problem with that key variable in getting to the household member. It also looks like this key variable is not involved in the linking from the household_member to reproductive_history table. So if folks have the same names across households (this happens in a lot of countries) you will have duplicate and confusing/erroneous options. So suggest adding that to the selection.
I am guessing the main problem relates to the parent_1 variable, which is key to the query going from household member to reproductive history. Parent_1 is in the model for household_member but is not defined anywhere I can find. That will make it impossible to query on that variable since it will always be null. Checking that in the member in tables to make sure it appears will be very helpful too.
Hope that helps, but let us know follow-up issues!