Hi everybody , i am new on Appsheet , my last program was made in VB6 , yes , i am a dinosaur in the programming world. I discover appsheet and is a powerfull way to make app very fast.
My problem i think is very simple :
I have two tables , "products" and "sales" , table products fields are "ID" , "Description" , "Price"
and "Stock" . Table sales fields are "ID" (which is ref to ID in products) , "Description" , "Price" , "Date", and "Qty"
When i select form view form from the table "sales" i can choose the ID and fill automatically the fields Description,Price and Stock from the products table. The user only fill the fields "date" and "Qty" . What i want is that when i save the Sale in this form , create an action that replace the stock in the table products with Stock(from Products) - (Qty from "Sales") , i tried Select , Lookup , but obviusly i am doing wrong. Thanks in advance
LinkedIn
Twitter
