Discount Matrix

[hobanwashburne]

Discount Matrix

Okay,

I have a discount matrix where each customer type gets a
different discount percentage on each part number based on what product family
the part number belongs to. The way it needs to operate is: A list of part
numbers is generated via other stuff (all of that works), but then the user
selects a customer from a different list (not linked to anything) and the appropriate
discount is applied.

Hopefully the attachment will be clearer.

[swuehl]

Have you tried linking your tables? Maybe Family with FamilyCode using AS to rename one of the two fields?

[hobanwashburne]

Yes,

If the tables are linked the Customer and Order list boxes are mutually exclusive. They need to combine to lookup the correct discount.

[swuehl · Accepted solution]

That's only because your CustomerType key values don't match (because of the CROSSTABLE LOAD, the values in the one table are text values only).

If you link your Families and correct the CustomerType key, it looks quite ok to me. Check attached.