AnsweredAssumed Answered

Pricing for items based on field values

Question asked by DavisSmith on Jun 8, 2015
Latest reply on Jun 8, 2015 by philmodjunk


Pricing for items based on field values


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?