I am making an app which will help manage a business. For some context, there are several sales officers and you assign several different kinds of products (both tangible and intangible) to them. I have more than five tables where you can add these transactions. My aim is to ultimately add all these transactions in a parent table which has five columns which will be:
- Transaction ID
- Account Title
Having such a table in excel would let me create a pivot table which would give me easy access to the inventory/balance of each bank/sales officer account. The issue is that each transaction in one of the five tables would create at least one debit transaction and one credit transaction (from one account to another). Therefore, I would have to add more than two rows to the parent table with one addition to any of the five tables. Moreover, if any transaction is edited or deleted, that change would need to be reflected in the parent table.
If I was doing this with excel and VBA then it would be quite easy for me but I am new to this approach so I would appreciate any help of suggestion. If anybody could even point me in the right direction, that would be great.