First off, I'm totally new to databases, forms and the terminology so please bear with me.
I manage a property with 50 tenants. I'm trying to create a way to have a list of current tenants that includes name, site number, monthly rent amount, and what they are paying for.
I then need to be able to track the date we received their rent, amount received, payment form (check, cash, credit) and their rent paid through date. Some people pay multiple months in advance.
Then ultimately an easy report that shows who is current on rent and who still needs to pay rent.
I've attached what I thought would be a start but can't figure out a: how to make the tenant name, site number, rent amount and options fields link to each other. Meaning, I receive rent from someone and I select them from the drop down and the other fields auto populate. then b: I enter the date received, form of payment etc in the subform and have it relate to the correct tenant.