0 Replies Latest reply on Aug 13, 2016 7:51 AM by chris.tidey@tideyelectrical.com

    Materials, stock and orders/worksheet

    chris.tidey@tideyelectrical.com

      Hi All,

       

      I am completely stuck at the moment, I have a worksheet layout created of which I want an engineer to be able to pick materials from stock.

      I currently have materials or stock ---->material_orders<------Orders with a portal set up in worksheet layout (worksheet table) I have then set up a drop down list pointing to materials ID but this doesn't work.

      Materials table         Materials_Orders        Orders

      MaterialsIDpk------->MaterialsIDfk

                                      Ordersfk<-----------------OrdersIDpk

       

      Whats wrong with this??? and where does stock IDpk fit in?

       

      Also I want a script in part number (in orders) to search materials and look up all the details in that record using a barcode scanner.