AnsweredAssumed Answered

Using a summary in a calculation then displaying result in a different table

Question asked by SandySpencer on Mar 4, 2012
Latest reply on Mar 5, 2012 by philmodjunk

Title

Using a summary in a calculation then displaying result in a different table

Post

I have spent several hours trying to solve what should be a simple problem and am finally throwing in the towel and asking for help. 

I have 3 tables: Jewelry; Bead Inventory; Line Items (used as a join table for the many to many relationships between beads and jewelry)

I need to summarize the number of beads used for each beadID across several pieces of jewelry, then deduct those beads from the bead inventory. I can succeed in getting used beads into sub-summaries sorded by beadID and then captured them in getSummary for use in calculations within the line items table. What I can't figure out and am most frustrated with is transferring the info into the Bead Inventory table. This should be a simple thing...if you have an inventory you need to deduct items as they become unavailable. I'm using Filemaker Pro 11.

I will greatly appreciate any help offered.

 

Outcomes