Count portal values and multiply by the quantity
Working on windows xp with filemaker 11 pro adv
I have a portal which gives the accessories for each Hose and the quantity of those accessories needed.
My portal looks up a accessory table which has the accessory name. I have 6 accessory names and a size per 6 accessories. eg 1" x 6 accessory names, 1.1/2" x 6 accessory names.
In my portal for a hose I may have :
1" Procap selected in the name field and in the quantity field x2
1" Enc Seal in the name field and in the quantity field x 4
Is there a way I can have all my accessory names (grouped by size ) with a total quantity count for the found count
If I could add the quantity field for each accessory name.
1" x procap = 20
1" Enc Seal= 30
Let me know if I need to clarify anything else