Hi Andrew

I can't believe you are making me expend more effort on this, but the discount field is not tied to the customer. It is not tied to the items either; it is tied directly to the order. If it were tied to the customer, it would be a field in the customer master table, such as the terms code. That is so obvious it hardly has to be mentioned.

Steve