I am a distributor with multiple resellers that I have to report back to the manufacturer with a summary of all reseller’s sales.
I have identical tables for each reseller (things like invoice #, MSRP, discount, reseller level, etc,), they are all the same.
I need a summary table that incorporates all the same information for all resellers so that it is basically a master table summary of all invoices (the individual invoice items do not need to be displayed here as it is on the reseller’s specific table), and grouped by year or reseller.
I have tried a number of ideas and am not getting what I am looking for. Any suggestions would be greatly appreciated.
@Kamille_Parks, I understand what you are saying but the manufacturer wants a separate page per reseller so they can monitor their respective progress in sales.
If there is a way to incorporate all of them with filtered views that may do the trick.
I am not very versed in this (it has been decades since I did any relational work in FileMaker), so to say I am rusty is an understatement.
Any guidance and help would be most appreciated.