Inventory Update On SharePoint 365

Hi Everyone,

I need help for how to update inventory quantity on SharePoint List

I have 2 SharePoint List :

1. Marketing Catalog (Qty Warehouse and this need update when have transaction on Catalog Order)

2. Catalog Order is Transaction Table, when quantity input it will be decrease quantity inventory on List 1 (Marketing Catalog)

List 1 (Marketing Catalog) and List 2 (Catalog Order) is connected with Lookup column IDCatalog

Can somebody help me for any ideas?