Hello,

I want to accomplish this to ease my reporting. Say I have these info;

Item Unit Price
A $10
B $20

If I were to do this;

Units Item Bulk Price
10 A
20 B

what can I do so that whenever I change the Item, the Bulk Price will also reflect the changes automatically (without having to add math functions in Bulk Price column manually).

Thanks.

kuzmi