Hi Guys,
I've scoured the internet the past few days trying to find if it would be possible to use access for what i'm wanting to do but haven't had any luck.
Im looking to set up a letting agency system and need a way to track rents for tenants and landlords.
For each tenant im going to need to add their due rent each month which will vary per tenant and also be able to input what rent has been received from each tenant.
I was thinking i would need to have a seperate table for each tenant and add the rents to this or have a table with all the tenants and a seperate table of received monies and set up a relationship between the two.
I'm just aware that adding lines or columns for each transaction may result in a very large database.
Any advice you can offer will be greatly appreciated.