AnsweredAssumed Answered

Count portal values and multiply by the quantity

Question asked by JessOttman on Oct 31, 2013
Latest reply on Nov 1, 2013 by philmodjunk

Title

Count portal values and multiply by the quantity

Post

     Hi,

     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 

      

     Thanks

      

      

Outcomes