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?