4 Replies Latest reply on Oct 3, 2012 8:04 AM by comment

    Creating table entries from the results of 2 other parent child relationships




      I am a newbie to Filemaker but have used MS Access so that's probably part of my problem.

      What I'm trying to do is take the results of a sales forecast for products and the recipes for those products and work out the quantity of ingredients I need to make the quantity of products that I will sell. I've attached a rough diagram of what I currently have and the outcome I'm trying to get to.


      Cheers and thanks in advance