E
EZZINGTON
Guest
Hi all,
I am trying to use Access to calculate bonus payments in a mult-level structure (network marketing). I.E. Person 1 recruits person 2, p2 recruits p3, p3 recruits p4 and so on, the linked levels can go down forever. Each record (person) is linked to the one above (by sponsor ID). For each person, I need to calculate down only 3 level below then stop. When anyone in the 3 levels of people sells a product, they trigger off a payment to the guy above (3 levels up). I can do it on a single level (obviously) but not going down to pre-determined multi-levels. I also need to calculate down to infinity when needed as well. How the hell do you do it, are there any geniuses out there that can help? Many thanks ....
I am trying to use Access to calculate bonus payments in a mult-level structure (network marketing). I.E. Person 1 recruits person 2, p2 recruits p3, p3 recruits p4 and so on, the linked levels can go down forever. Each record (person) is linked to the one above (by sponsor ID). For each person, I need to calculate down only 3 level below then stop. When anyone in the 3 levels of people sells a product, they trigger off a payment to the guy above (3 levels up). I can do it on a single level (obviously) but not going down to pre-determined multi-levels. I also need to calculate down to infinity when needed as well. How the hell do you do it, are there any geniuses out there that can help? Many thanks ....
