Help needed with Many to Many relationship

I will assume that it is just the only or the most recent Audit info that you need to float up to the Parent record.
Kill the Bridge table.  You do not need it.

Make a relationship directly where 1 Site info has many Audits.
Make a summary maximum of the Record ID# of the Audit, call it [Record ID# of Most Recent Audit].

Make a new reverse relationship where 1 Audit has many Site Info but for the reference field on the right side use that field [Record ID# of Most Recent Audit].

Then simply look up any field you want from Audits to Site Info.

If you for some reason you do want to retain the bridge table (not needed though, I re-state) , then you would need to look up the audit data down to the bridge table.

Then you would need to do that same reverse relationship between the Site info and the bridge table.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------