Using a summary in a calculation then displaying result in a different table
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.