I have a list of parts and a list of customers. Parts have standard pricing and customers get contract pricing.
My data looks something like this:
Table: standard pricing
Table: Customer pricing
| Customer |
Price A |
Price B |
| X |
$4 |
- |
| Y |
$6 |
$9 |
| Z |
- |
$11 |
What I really want to do is be able to look at Part A and see standard pricing AND customer pricing. Like this:
| Part |
Standard |
X Pricing |
Y Pricing |
| A |
$5 |
$4 |
$6 |
I could create a column for each part number or for each customer but I have 100+ parts and 25+ customers, each only gets 2 or 3 parts. I can link a part number to a customer but I want to link back their custom pricing to all the parts that they purchase.
Sorry if this answer is elsewhere. I tried looking and searching tutorials and what not…
