AnsweredAssumed Answered

Summary Data from all tables on one layout

Question asked by Danxyz on Jan 8, 2011
Latest reply on Jan 10, 2011 by Danxyz


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.