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.