Wanted - Database for a Property Management / Letting Agent

[mshawn]

It's always best to know details and background of any agency before getting their service. This will save you from getting a bogus agency that would just swipe you out. You can always check online for the best program.

 

[vbaInet]

Spammer - mshawn - reported

 

[mshawn]

I am soo not a spammer!!!! duhhh!

 

[Shama]

So did you make the database? I am also starting to make the database for renting apartments in a building but can't afford to hire someone to do it for me. I have building which have 300 apartments, furnished/unfurnished of different categories (studio, one and two bedrooms) and rented on monthly, weekly and quarterly basis. My company is paying rent to the landlord of the building. I assume I need to have
1. Table for property (all apartment numbers, furnished/unfurnished etc)
2. tanents
3. leases with tenants
4. payments

How do I create the relationships and how do I make a data entry form and follow up on due payments and vacant apartments and create reports.