Hello,
first question:
I have the two tables Storage bin and Item. Item has the attributes bin location and Storage bin has attribute ID, date, amount and status(free or occupied). Through the attributes ID and bin both are in a relationship. I want to achieve, if someone creates an item in table item with a new bin, then the status of this bin in the table Storage bin should change from free to occupied. Thank you.
second question:
I would like to build an inventory history.
That is, if someone changes the quantity of an item, this would be recorded and noted with the respective date. How could something like this be implemented?
Thank you very much.
first question:
I have the two tables Storage bin and Item. Item has the attributes bin location and Storage bin has attribute ID, date, amount and status(free or occupied). Through the attributes ID and bin both are in a relationship. I want to achieve, if someone creates an item in table item with a new bin, then the status of this bin in the table Storage bin should change from free to occupied. Thank you.
second question:
I would like to build an inventory history.
That is, if someone changes the quantity of an item, this would be recorded and noted with the respective date. How could something like this be implemented?
Thank you very much.