Summary fields from dynamic field names
FM Pro 10 & 11, Filemaker server 11, Shared Windows Network (XP & Vista & 7)
I have a table with product fields (many)
Most of the products come in three variations (c, b, s) There is a field for each, as well as a combined calculation that totals them (all) (four fields per product)
I want to create a report where I can select a product from a drop down list and it will show me a summary total of the 'c', 'b', 's' and 'all' fields.
I have created a 'on object modify' script trigger that produces the four field names, depending on the product selected, using four unstored text calculations when a global product ID is selected
i.e. select..... Product = 20x30 Print (select this from value list)
create..... fieldnames pr_c_2030, pr_b_2030, pr_s_2030, pr_all_2030
Where I'm having trouble, is using the calculated results as field names when I want to create a summary total. Is there a way of allowing calculated results as field names in creating summaries? or have I been going down a dead end path here?
Any help would be appreciated