How would YOU structure this?
I'm pretty new to FileMaker Pro but have quite a technical background and pick things up pretty quickly. Let me lay out the scenario of what I'm trying to accomplish and I'd like to hear how you would structure it.
I have several sales reps. Each of these sales reps has multiple accounts that they've signed. There are commissions associated with these accounts that they get paid.
I'm trying to create a database where I can enter in personnel info for individual reps to be displayed at the top of the page. Beneath that there would be 2 or 3 tabs associated with their accounts. On one tab I would like to be able to add their accounts, one row for each account. I want to be able to add many accounts here as this will grow over time. On each of these rows I will have fields corresponding to their commissions that get paid out over a one month period. I will then have a 2nd tab that keeps track of commissions they get every month from these accounts.
My question is, does this need to be done using two tables? 1 for the rep info and 1 for their accounts? Or should I just use one table?
Please let me know if you need any more info.
P.S. - Using FileMaker Pro 11 on Mac OSX 10.6