Good day to everyone,
I need your assistance, I'm trying to create a system which lets user create product requests, the idea is that this screen catchs all important info from user, I was able to create a pick list where user can choose what product to pick, then its cost should auto populate to its correspondant value, then that cost should be multiplied by the qty of items that are being delivered and finally that should be equal to a total.
To make the story short, it'd be like this:
I have an item order form where users can request products.
The way it's set now, starts when user selects a product from "Producto" pick list, then "Costo" cell gets autofilled with it's corresponding cost value, then "Cantidad Entregada" multiplies "Costo" value by it's corresponding data input by user.
What's happening is that the following cells are sending it's data to a table called Base_de_datos to be storaged and where all requests will be saved
Cantidad Solicitada
Cantidad Entregada
Subtotal
The ones not sending their value are
Product ( pick list )
Costo ( autofill when selecting a product )
How can I make Product and Costo cells transfer their value to Base_de_datos table ?
As you can see, in the app, although I choose a product from the list and its cost gets autopopulated, it does not update or sends its value to my Base_de_Datos table, and system ends up not being able to get a good multiplying calculation.
Hope I explained myself 
