Dont think Access can help, well not sure

Hi all,

I created a database for my company and it works very well but, I need it or something to track the way I pay comisions. Its a type of multi-level company and pay rates vary. Also, once someone hits the top level they now join in profit sharing. The profit sharing part is the tough part becase say person A is at the top he is a team leader and he gets money not only from his sales, but also from the people in his group below him. It must also be able to pay the correct person if someone quits, say Person D, the system knows that it all off person D's people under him go up to person C now. I hope this isnt to confussing, but im starting to confuss myself as im trying to set this up.

Is access able to keep track of an organization like this or should I try to use something else?

Thanks.

Scott

Scott, I think maybe you need some kind of hierarchical structure, and from what I can tell surfing this forum the common way to do this interface wise with msaccess is with the treeview control. I just posted a sample db for this at

http://www.access-programmers.co.uk/forums/showthread.php?p=445342#post445342

Maybe that will be some help for you. Also I have a collection of social bookmarks involving database and trees, most (though not all) involving msaccess, at

http://del.icio.us/tphyahoo/tree

Good luck!