I have created a property management base where I have multiple properties and for each property, I have multiple tenants. In the “Tenants” table I have all the information of the tenants (rent, deposit, move-in date etc.).
In addition to that, I want to enter monthly rents received by the tenants and also their electricity bills.
I have thought enough but not able to figure out a way to do the same. Please help me out with this one.