Bridge between 3 tables not filtering

[querymonster]

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!

[lbendlin]

a 1:1 bidirectional link usually tells you that these two tables can be combined.

[querymonster]

thank you! I understand you mean I should merge these tables? It's actually a 1 to many relationship because the farmer ID can be repeated in the bridge..

[lbendlin · Accepted solution]

Read about the concept of facts and dimensions. Bridge tables are usually and indication of a data model that needs to be redesigned.