1 Reply Latest reply on Feb 10, 2014 11:57 AM by davidanders

    Best relationship approach for work orders with parts...

    productionQC

      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