There should be a unified view that links together all records and all tables (all linked records “left joined” automatically, or could be an option of left, right, outer or inner). This way, you could apply features such as roll-ups and counts witho...