Assigning Fees to Multiple Types of Recipients at Different Times
Relationships are as follows (accounts table is the core):
accounts -< fee terms -< fees
accounts >- dealers
accounts -< account brokers join table >- brokers -< reps
accounts >- managers
accounts >- sponsors
I want to set up portals in each of these (sponsors, managers, brokers, dealers) tables to display the fees they receive. I think I probably have to make duplicate tables, but it's not working for some reason. I might be in a little over my head, but that's how you learn... Thanks in advance.