Thread:Zonko64/@comment-43596541-20190921071205/@comment-43596541-20190921162914

This   N * Times the 4 Assmeblers for a Collection, I can do with the actual COLLECTION DETAILS file as it has the 4 Assemblers and Qty's in  separate colums ... You could actually do it right now  just  use the filter  on the "Collection" column then below the table  add a Qty field  and formula to do N * Qty for the 4 assemblers ... Not as good as a  Form  but it does the Job ;) ... I will do a sample   ...

You gave an  idea for a "shopping list" where you would put: Collection-ID  -  QTY xxxxxxxxxxxx 10 xxxxxxxxxyyy 12 zzzzzzzzzzzz  6 And this produce a list of Assemblers with  Total Qty Reduired Asmblr 1 Asmblr 2 ... Asmblr N

Adding  Qty's for Assembler that common to more than one collection like the Red Elixir, Rock Crytal, Vase, Emerald Phenix etc ...

I'll post a screen shot of the  results of my test if it works  ...

BTW I did not people people stacked up that MUCH of collections !!! I'm happy to give my surplus aways when I have more thab 2  (^) ... I'll thinking about being a bit more selfish for some "high energy" Collections ... Or collection I always zillions of Assemblers for like Art of Ballet and a couple others that use the  Petroluem Lantern &  Candles or something like that ...

HAPPY GAMING