AnsweredAssumed Answered

Summary fields from dynamic field names

Question asked by david583 on Feb 4, 2011
Latest reply on Feb 10, 2011 by philmodjunk

Title

Summary fields from dynamic field names

Post

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

Outcomes