[GreatLakesVacuum]

Ok on the drop-down.

Our customers don't pick their affiliates...the affiliates refer them to us... so a customer is only associated with at most one affiliate. You are right that an affiliate could be associated with multiple customers though.

I guess maybe we would rather just have the affiliate linked to the customer than the order(s).

For example:

We have a company that buys through us for other companies, call them Stanley. Stanley is now an affiliate... they currently order from us and have us drop-ship to their customer and they sell at the same price we do but we give Stanley a 20% discount. This means Stanley pays us and their customer then pays them.

Then we started selling parts online... now some of Stanley's customers have ordered directly online from us... which means we received the payment immediately. Stanley is unhappy about this and wants a piece of it. After extensive discussions a compromise was made that they would get a cut of orders placed by customers that were already customers of theirs (and that they told us about ahead of time) but it would only be 10% as we are doing all the work and they (Stanley) are doing nothing.

So basically I am looking for a way to get Stanley their 10% when a customer account that is a customer of theirs orders from us online.