Summary Data from all tables on one layout
Is it possible to display grand totals for several fields from different tables on one layout? I have a wine database and would like to show a Summary layout where I display things like Total Number of Bottles, Total Number of Producers, etc ... Basically a summary of totals across the entire database.
I have created summary fields in each table and they display correctly when that table is the reference for the layout. But summary fields from other tables only show the value from one record.
Must be another way to do this.