AnsweredAssumed Answered

Auto enter feature in portals

Question asked by drraf on Jun 22, 2012
Latest reply on Jun 22, 2012 by comment

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

Outcomes