Skip to main content

Hello,


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.

You likely need another table for Payments, where each record has fields for the Tenant, the item (perhaps a single-select field with options for Rent and Electricity), and the date received.


Reply