I have a Materials / Stock ----->Materials_Orders<------Orders tables, I currently have a layout called worksheet which if you pick the Material ID it then fills out the materials detail from the stock cell. But what I want to do is when you pick quantity in the portal on the worksheet I want it to deduct the stock in my materials table. Ive tried Material::Amount in stock - Materials_orders::quantity and it returns a minus number.
I would also like to do a search bar in the worksheet materials table so that they can search for the materials and add them to the portal.
Ive attached the file.