currently i am using file maker pro 11 for my production and inventory control using these relationshsips i.e.
Batches ----- Production orders------- Production order Line items ------ Products
Now i want to connect above tables with my formulation table comprising formulation and formulation_line items, so that i just put batch name and my production order get automatically updated by taking data from formulation table. So that i dont need to manually fill production order.
Can anybody guide me how to do that?
Thanks in advance
With the limited infromation you have provided, I guess that you will have to write a script that does what you do manually. Start writting a list of steps the you do. Then use that to write the script.