Just throwing some thoughts out there for you.
These are interrelated by relationships. Rentals can have multiple tenants, at one time (shared leases). Tenants can have more than one lease... a new lease is signed every year, every five years, etc.
There is a similar thought process to Accounting and Tasks.
Thanks TKnTexas. Thing is it is Properties that will have multiple tenants, not Rentals, so is there any need to have a table for Rentals?
I think a set definition needs to be decided:
Properties = 1 record for each physical rental unit.
Tenant = 1 or more People renting 1 property
Leases = (suggestion) A join table connecting Tenants to Properties where one record = a lease agreement for a fixed period.
This is my conceptualization based on being a payables person paying for different locations we held with a lease.
Thanks for that, makes sense :)