I have a problem when I want to take last_stock on an item
with a relationship like this, I want the table item to have last_stock like in the stocks table
a problem was found when I wanted to retrieve the last last_stock from the item_id to be searched
how to fix this?

i confused with this problem, please help me
databasein view itemin view stokI use modal to info the last insertthis is view in table stock, last_stock update when new data is entered