Let's start with a low tech solution as it seems pretty complicated to know which is the previous record.
Quickbase supports tables being related to itself. My suggestion is to do that and name the field for the [Related Lease] to be called [Related Previous Lease]. Then do your lookup fields and name then like [Previous Rent], [Previous Terms] .. whatever fields you need.
Each lease will have a button on it to add a Lease Extension or Renewal. So at renewal time you launch off he old lease to create anew one. That also has the advantage that you could chose to auto populate many fields by enhancing that Add Lease button as for example the [Related Building] will be the same and the [Related Client] will be the same.
It would also be possible to have a report link field on the lease to show all the leases for the same client and property.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
