2 Replies Latest reply on Jul 18, 2011 10:37 PM by kellywillsoin

    Real Estate rental management

    GuyWinter

      Title

      Real Estate rental management

      Post

      Hi

      I am trying to develop a real estate rental database to keep track of my small portfolio of properties. I am having one stumbling block however: I have a property table including the data about the properties, a tenant table, an agent table and a tenancy table for each individual tenancy. When I want to open a new tenancy I have a drop down list of properties in my portfolio, the problem is that i only want those properties that are not currently rented out to show in this list. When a tenancy is over I want the property to go back onto the "available" list. Any ideas??