I work in real estate and I’m trying to create a database of information on apartment buildings including basic info like address and owner as well as rents for each floor plan in the building (and the ability to store historical rents). My idea for the design is currently as follows:
- Properties table - contains the basic information of each property
- Unit List table - contains the date that the rents are current as well as average rents, square footage, and rent per square foot for each type of unit (ie studio, 1 bedroom, 2 bedroom, etc). I plan to relate this with the property table.
- Unit table - this will hold the information for each individual floor plan: type (studio, etc), rent, square feet. This will be related to the unit list table.
My question is concerned with the execution of something like this. I would like the form that I create to be dynamic, in that I want to have fields for all the basic info on top, but then a date field that will have a drop down of all the dates that rents have been entered for that property in the past as well as a “Today” button to set the date to the current date and create a new unit list record. The below that, I’d like to have fields for one unit, with a plus sign button that adds rows of fields for additional units that will all be related to that specific unit list.
Also, how would I go about populating the unit list records using formulas and values contained in the unit table?
I can mock up a form in the way that I’d like to get it if that would help make things more clear, but any help would be greatly appreciated. Thanks!