Commissions and Residual Fees

[shoil]

I need to calculate an initial commission fee, then a monthly residual fee for 2 years (as long as the referred account stays open for the 2 years). Can anyone give me a clue as to how to begin? Much appreciated....

[LiveOak]

Probably not without more information. What is your file structure? What are the formulas for your initial commission fee and monthly residual fee?

-bd

[shoil]

What I'm trying to design is a set of records to keep track of commissions for an affiliate program. One idea we had was to give each referred account a unique number, then calculate the commission on their individual record and post the result on the affiliate's record (probably in a related database).

We will pay out the commission when the affiliate's account reaches $50 or more. Then funds will begin to accumulate again. I will post again when I have thought this through a bit more. All ideas welcome and greatly appreciated.