The project would loop on the top row 1 - 30 horozontal columns representing the number of an item (ex: 1- 30 widgets). The vertical rows would be a representation of how many items sold per day. Sales 1 to 20 sales per day of that widget. The corresponding fields that line up by column and row would represent the resulting price based on number of widgets * num sales for that day. (ex: 5 widgets * 10 sales of each * a static price of $10 = $500 per day). Of course the price I would be changing based on a separate field. Hope my explanation makes sense.
Since in FMP it seems even when you loop values you have to create the tables with those fields to do so unlike creating dynamic temp values on the fly online. This requires more setup in FMP which is fine. Not sure the best way to set this up. I was going to create two tables with a third join table and fourth default price table that would basically hold the price. Example would be table #1: widget table with 30 entries in it or loop them dynamically, table #2 sales table representing 1 - 20 sales per day. Table #3 would be a join table those two tables matching 1 to 1, 1 to 2, 1 to 3 etc. This has the potential of getting big so looping is probably most efficient. Table #4 would be the price table allowing me to modify the price as I need to for user interaction basically to avoid putting a static price in each entry, avoiding redundancy of course.
Hope my explanation made sense. Still very new to Filemaker Pro so my understanding of the coding end is very much on the novice side but I am picking it fairly quickly and loving some of the built in features which is saving me a ton of code and time.
I appreciate any input and open to any direction that might be more efficient than my process so far.