too many forms open

[Jaad]

Hello All,

I have a design problem with my database. I administrate apartment buildings and the current table structure that I have doesn't seem to work. (I have enclosed a snip of it)

The current design doesn't allow me to print or to save my condition report as PDF.

Here is what I am dealing with: I must perform a Condition Report on any suite that gets rented out.

The information required is as follow:

I have buildings which all have Locations(or suites). these locations all have rooms and all those rooms have component that must be evaluated and rated according to a list of codes. I must perform this report at the Move-IN and at the MoveOut stage and must include both report on the MoveOUT to show how the location was at the begining of tenancy and how it is now at the end so if there is damages it can be deducted to the security deposit.

In my sample database that I uploaded you would login as Alain and then go to the form LocSymbioseQF and click "Location Condition Report" link on the left top corner. this will bring you to the report I need to create but can't given that my table structure isn't working.

I have had a few suggestions on how to build my tables but find myself in a bit of a pickle at trying to merge all those together and I do not understand how I would be able to then update after I need to change a Location.



this is a sample I am trying to establish:

    
tblTenant   'holds your tenants' info
    FIELDS
PK  TenantID
    TenantName
    etc... (other tenant-specific data)
tblBuilding   'This holds all of the data for a specific building 
FIELDS
PK  BuildingID
    BuildingName
    BuildingAddress
    etc...
tblSuite  'This holds all of the data for the specific suite
    FIELDS 
PK  SuiteID
FK  BuildingID
FK  TenantID
    SuiteNumber
    etc...
tblRoom   'a lookup table to give you all of the room names (kitchen, bathroom, etc.)
    FIELDS
PK  RoomID
    RoomName
    RoomDescription  'in case you want to provide a long description of the room
tblSuiteRoom   'An Interim table to select Rooms for each Suite
    FIELDS
PK  SuiteRoomID
FK  SuiteID
FK  RoomID
tblRoomComponent  'what component belongs in each room.
    FIELDS
PK  RoomComponentID
FK  RoomD
FK  ComponentID 
tblComponent 'The table that holds every possible component.
    FIELDS
PK  ComponentID
    Component
    ComponentDescription
    etc...

tblWalkThru
Key FIELDS          TYPE         
PK  WalkThruID      AutoNumber
    WalkThruType    Text     'Combo with In, Out, Interim as values
FK  SuiteID         Number  'the SuiteID from the Suites table
tblWalkThruItems
Key FIELDS          TYPE         
PK  WalkThruItemsID AutoNumber
FK  WalkThruID      Number  'the PK from tblWalkThru
FK  RoomID          Number  'the PK from the Rooms Table
FK  ComponentID     Number  'the PK from the Components table
 

Sorry if any of this didn't come out right this is my first post here

Cheers