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