4 Replies Latest reply on Jun 8, 2015 1:03 PM by philmodjunk

    Pricing for items based on field values

    DavisSmith

      Title

      Pricing for items based on field values

      Post

      I'm working on a quote system that allows users to select different items and have them priced.

      The user selects sink name, color, and material. I have color and material as conditional value lists based off of the sink. Now I want to add in price for each sink.

      My current set up is having my price field as a calculation that uses cases to determine what the price will be. I want to make it easier to edit for someone who isn't familiar with filemaker. Ideally, I would have the prices stored in the same place where I have all my sink names stored.

      I can't just store the price in each record of the sink name because the price changes depending on color and material.

      Any suggestions on how to set this up?