Need a solution on table to table relationships

Your application structure will need to be a little more complex to achieve this. Instead of just Leases and Daily Reports, you'll have to have another table that is a child to both of these - possibly a Lease Reports table or something. This is the table that you would use to capture the Lease information as of that date - using Snapshot fields, probably. 

If you're comfortable with Automations, you could setup something to automatically generate these records each day, so that the Property Managers would just need to complete any additional information that might be necessary.

------------------------------
Blake Harrison - DataBlender.io
Quick Base Solution Provider
------------------------------