1 Reply Latest reply on Jun 22, 2012 2:16 PM by comment

    Auto enter feature in portals




      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