Logical Script Help?
I'm a filemaker novice and have to set up a database to track orders. Some of our mfgs have quantity pricing. When entering an order, i need the cost of the item to be based on the quantity ordered. Is this done with a script? In the products table, i have different fields for the quantity breaks, such as 1 piece, 6+, etc. So if I enter a quantity of 6 or more pieces, how do I get it to pull the 6+ price?