AnsweredAssumed Answered

Best relationship approach for work orders with parts...

Question asked by productionQC on Feb 10, 2014
Latest reply on Feb 10, 2014 by davidanders

Title

Best relationship approach for work orders with parts...

Post

     Hello, I am making a work order system to look after our fleet of vehicles.  We have many trucks, a shop, and a large inventory of parts.  I have built the parts inventory table based on the template "Inventory".  I have also made a table for the truck fleet.  I am in the process of making a table called Work Orders.  My question is this.  When a user starts a new work order they will select the truck from a drop down populated by the truck fleet table.  They will then add parts.  I need the part to be removed from inventory and copied over to the work order.  Should I just a portal from inventory?? What is the best approach for removing the part and placing it in the work order permanently. 

     Please see picture for table relationships...

      

Voila_Capture68.jpg

Outcomes