Bridge between 3 tables not filtering

Hi everyone,

I have three tables:
1- Actividad: activities registered daily by the agronomists for farmers they visit, some of these activities can be group trainings. The columns "Individual" and "Grupal" indicate the name of the training.

2 -CapGrupal: farmer IDs of the farmers trained

3 -Padron: farmers with their info (village, full name, ID, etc)

For each activity recorded (= for each _record_id), there is a farmer ID if the activity is individual. If the activity is grouped, the farmer IDs are in the table "CapGrupal".

When I select the name of a farmer, I can see the content of the column "Individual".

However, I cannot see any data in "Grupal".

I created a bridge table which can't seem to fix the issue.

What could be a solution to this?

Thanks a lot for the help!