I need to create a summary table that counts the number of times an individual product shows up in a list of linked records.
For example, I have a table called “Assortments” and a table called “Fruits” that are linked. Assortment 1 has 2 apples and 2 pomegranates, while Assortment 2 has 1 apple and 2 pineapples. A third table, “Orders”, lists the assortments ordered.
How can I summarize the data from the “Orders” table into how many of each individual fruit has been ordered (X apples, X pomegranates, X pineapples)?