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
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.