Relationship Fix

[Ja4]

I have a Team and Site tables connected by Team name:

Then these Team, Site are connected to a Results Table by SiteCode

On the Target table I have SiteName2, and Site.SiteCode have can I connect to the Site table to enable filtering by Team.

[BrunPierre]

Hi, The inclusion of the 'Team' table seems unnecessary given that Team field is already present in the 'Site' table. To retain merged field records (Team & SiteName2) from tables 'Site' and 'Target' whenever there are matching values in SiteCode field, an Inner Join would be appropriate.

[Ja4]

Thank you I'll give that ago.

[Ja4]

Unfortunately the solution didn't work, due to the table set-up in the source data base, but you have given me some ideas.