40 Level Markup Table
Looking for the best way to assign a markup % to individual records in an estimate item table. Markup is based on the total cost, not based upon the product selected. For example 5 pieces with a per...
Forum Discussion
I appreciate all the help. I ended up breaking my markup chart into 6 levels with a granulated scale for each level, ie min amount, max amount, qty of options within the level and the starting markup rate for that level. I created a Markup Table with a child table for my Markup Details. I then select the correct Markup record in my Estimate table and pull in some related Markup lookup fields into this Estimate record. I pull some of these same fields into my Estimate Detail table and then have a relationship between my Estimate Detail table and my Markup Detail table to pull in the factors required to determine the correct markup for each record in my Estimate Detail table. Everything seems to be working as expected. This method allows for a different markup table to used in the future without affecting past records while not having to have 40-80 lookup fields within the Estimate or Estimated table.