Table design issue !!

[Greg]

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

 

[Jackie]

Greg
I would definately include a table which would include tenant id, rent amt due, due date, rent amt paid and date paid

You can then populate the rent due and date due from you original rent table but then the amount could be altered for each tenant. I do not know how your program is set up but there are any number of ways to populate the new table for each month/payment period and then apply the payment to that record

Hope this helps.

 

[Tim Ferguson]

I would definately include a table which would include tenant id, rent
amt due, due date, rent amt paid and date paid.

Because rents may be paid quite asynchronously from when they become due,
I'd be tempted to have a RentsDue table and a PaymentsReceived one?

Tim F