Howdy All,
How do we get multiple child tables to aggregate into a parent table both cleanly and automatically as child tables are updated?
We remarket equipment for hospitals, so we have several inventory lists. We keep those lists in tables on a tab, one table per tab. A corporate body often oversees hospitals, and individuals at those corporate bodies often wish to analyze all hospitals' data at once. We want to be able to aggregate several tables into one table automatically. It would be helpful to find a way such that as individual hospital inventories are updated, a master list is aggregated. The master list could then be published for use.
THANK YOU!
AndyParker
