Hi
I am designing a small rent property database in access 2002

i have my designe all normalised but i am having a little problem in
recording the rent payments and the amount paid.

the property table contains the rental amount per week
and i have a tenant table that has start date , end date , payment cycle
 eg weekly fortnightly, amount paid and paid till.

my problem arises when rent amounts change for the property rented , how
do i get around this one.

should i do a seperate table for example lease which records the rent
for that period and group payments by that

any solutions greatly appreciated

greg