AnsweredAssumed Answered

Assigning Fees to Multiple Types of Recipients at Different Times

Question asked by spectre6001 on Mar 3, 2010
Latest reply on Mar 5, 2010 by philmodjunk

Title

Assigning Fees to Multiple Types of Recipients at Different Times

Post

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.

Outcomes