Probably a basic question, but:
Each Quote has one construction and can have multiple prices.
The problem is this pricing was set up on a matrix. In the UnitPrice table, there may be a quantity for 500, 1000, and 2500. Each with a seperate per thousand price.
I need to get the unit price into the QuoteQuantityPrice table, but the amount quoted might be 1250 or 2000, and I need to lookup the price for the lower quantity.
I've tried lookups, but I'm not getting anywhere.
Any advice would be appreciated.