Hi, I am designing a Real Estate Management Database where i can manage my Property and all the record related to my tenants, property expense, rent received, rent due etc. I have some Questions where i am stuck in finding the solution, first of all I have a tblBuilding where i can add my property having BuildingID as Primary Key, then i have a tblUnit where i can add Multiple Units of Property having BuildingID as a foreign key. After adding Property i then have a tblLease as an agreement table that is linked with tblUnit and tblProperty as well.

As if the property is of SingleUnit nature then it have only one tenant so a one agreement (direct r/ship with tblLease) and if a building is multiUnit then its unit are linked with Multiple tenants and Agreement. Iwantv App Free Download For Pc. While creating a group by Query where i have to display my Building and Sub Units (if any) with tblLease having [Last of Rent Amount], [Last of Agreement Start Date], [Last of Agreement End Date]. Running this Query give me the errors of, I have more questions regarding Agreement and rent calculation, how ms access remind me about the rent due amount and balance and is this possible to automatically increase rent by 10% of every tenant after 12 months, Review my attached database for info? Fritz Fax Dbf Tool Exe Download. Please guide me in designing this database software?