Database based on mobile number and reflects in two sides after the second user register

Hi All

I have problem with creating my database

My data based on user mobile number - Lending and borrowing

Registered User will add a person mobile number ( not user yet ) and will record lending transaction

I can show filter based on the mobile numbers the registered user added to his list .

The problem is :

When new user register and he has borrowed from existing registered user how it can reflect this .

In other word - the repeating list to show the lended and the borrowed amount related to the registered user .

Database based on mobile number and reflects in two sides after the second user register

The same concept of the splitwise app

Hi @Akramebid ,

How about in the transactions (lending or borrowing) store 2 phone numbers and there is another collection which accumulates those transactions and store only 1 phone number which can be used to filter.