Relate Tables (Multiple Tables)

[jmonroe918]

I need help getting a column of data from one table into another table, through third table.

The end result is I need the data from 'Site' in the Audits table to be listed in the Audit Findings table.

Here's the background:

• Audits are created with an 'AU-" number. Some Audits have Audit Findings with an "AUF-" number. The "AUF-" is connected to the "AU-" in the relationship tables.
• The Audit Finding links to the Audit Finding Relationship table with the ID. AUF-00002 lists AU-00002 as the 'Finding Rel Obj Name'. AU-00002 lists Vista as the 'Site'.
• I need to list Vista as the 'Site' in AUF-00002 (So I can then create a chart showing Audit Findings Per Site") 

I've tried using Mapping, Left Joins, etc but can't seem to get it.

Any help is appreciated.

The QVW is attached.

Thanks

Jeff