0 Replies Latest reply on Jun 12, 2012 4:39 AM by drraf

    Portals

    drraf

      Dear,

       

      I am using Filemaker Pro 11 for my production work.
      Currently i am having following related tables i.e.

       

      Batches_table ------------- Production_order_table----------- Lineitems_table --------- Products

       

       

      At the moment for every new production order i have to manually enter all twenty ingredients in the recipe and then a script is run which subtract that much quantity from the inventory.

       

      Now i want to add a functionality in which i just want to add a new recipy table so that when a new production order is made , it automatically pulls recipy of twenty different ingredients from the formulation table and when i run script it automatically subtracts from inventory. So dont i dont need to add each of twenty ingrediients in production order every time.

      Can somebody help me what kind of scripts i should run.

       

      Looking forward for early reply.

       

      Best Regrads

      Dr Raf