Ok, I am fairly new at complex coding, this seems to be simple but I just can't think of a process for it. Any suggestions would be greatly appreciated.
I have a subform called "OrderDetails" and a main form called "Orders". They are linked by OrderID. In the "OrderDetails" subform you select the products (From a products table) for the order and then enter the quantity. Products ship in drums. Product pricing varies by drum quantity. It take into account the whole order (mix and match).
Example of Pricing:
Product Name 1-10 Drums 11-20 Drums
Product X $2.00 each $1.00 each
Product B $3.00 each $2.00 each
So if a customer orders 5 drums of X and 11 drums of B they will get pricing based on the total drum quantity (16 drums). I have a field on "OrderDetails" that calculates the total number of drums ordered. I need to now update the cost field based on this total. For this example I would need it to find Product X, look for the proper pricing column based on the total quantity then insert the price into the Cost field. Any ideas? Unfortunately there is no systematic reduction in pricing like my example shows. Thanks for all of your help.
Jennifer
I have a subform called "OrderDetails" and a main form called "Orders". They are linked by OrderID. In the "OrderDetails" subform you select the products (From a products table) for the order and then enter the quantity. Products ship in drums. Product pricing varies by drum quantity. It take into account the whole order (mix and match).
Example of Pricing:
Product Name 1-10 Drums 11-20 Drums
Product X $2.00 each $1.00 each
Product B $3.00 each $2.00 each
So if a customer orders 5 drums of X and 11 drums of B they will get pricing based on the total drum quantity (16 drums). I have a field on "OrderDetails" that calculates the total number of drums ordered. I need to now update the cost field based on this total. For this example I would need it to find Product X, look for the proper pricing column based on the total quantity then insert the price into the Cost field. Any ideas? Unfortunately there is no systematic reduction in pricing like my example shows. Thanks for all of your help.
Jennifer