Hey guys, i need your help
I'm currently making an application about borrowing tools from the warehouse.
I have 2 tables which are "Warehouse" and "Checkout". "Warehouse" is a table of tools that can be borrowed. And "Check Out" is a table to record and track who borrowed tools from "Warehouse".
"Warehouse" has three column [serial_number], [item], [amount]. App converts value of [serial_number] to a QR code. While "Checkout" table has four column which are [serial_number], [item], [amount] and [last_stock].
[serial_number], [item], [amount] are ref type from "warehouse" and [last_stock] has formula [Amount]-1.
is there a way the [last_stock] value is also copied to the [amount] column in the "Warehouse" table when the user borrows the tool?
thank you very much for your help.
cc @Steve
LinkedIn
Twitter
