L
LauriS
I posted this in the Query section but I think it really should be here. So
here's the short version. I track photography orders. Photos has one record
per order, PhotoList has one record per picture order (based on pic # and
size). Price of each pic is based on the TOTAL number ordered of that size
(we give a discount for 6 or more photos ordered of the same size but NOT
necessarily the same photo). I'd like the form to calculate the price for
me. Here's a run through:
Order #1, pic # 3345, size 5x7, quantity 2 (price would be $7 ea)
Order #1, pic # 3346, size 5x7, quantity 2 (price still $7 ea)
Order #1, pic #3350, size 5x7, quantity 3 (price now changes to $5 ea for
ALL the 5x7s ordered - the ones above and any more on this order)
I'm thinking the easiest way would be to have a button on the form that
calculates the line item prices and the order total after I enter everything?
here's the short version. I track photography orders. Photos has one record
per order, PhotoList has one record per picture order (based on pic # and
size). Price of each pic is based on the TOTAL number ordered of that size
(we give a discount for 6 or more photos ordered of the same size but NOT
necessarily the same photo). I'd like the form to calculate the price for
me. Here's a run through:
Order #1, pic # 3345, size 5x7, quantity 2 (price would be $7 ea)
Order #1, pic # 3346, size 5x7, quantity 2 (price still $7 ea)
Order #1, pic #3350, size 5x7, quantity 3 (price now changes to $5 ea for
ALL the 5x7s ordered - the ones above and any more on this order)
I'm thinking the easiest way would be to have a button on the form that
calculates the line item prices and the order total after I enter everything?