Right now, our product price is based on how many of something is ordered. Currently, I'm doing that with a one-to-many relationship from a Products TO to a Price Range TO. The attached file gives a very basic idea of how we're doing our pricing. Amount of something ordered determines price.
Now there's an extra layer going onto it. Each job will get a rating of easy, medium, or difficult. Then the price range for some items will shift....same quantity thing applies. The complexity thing will only apply to roughly three products out of several thousand. They are common products, however, that will be featured in every quote.
Is the BEST way to do this to create a "complexity" TO, or is there a smarter way to pull it off?