I would think that a many to many table between units and rooms would be ideal
for this.
A table of all units tblUnit => UnitID
A table all room types tlbRoomTyp => RmTypID
and a junction table to tie them together
tblRoom => RoomID, UnitID, RmTypID, ConditionID etc....
I assume that you have tables for Property and Building though building may be
optional.
Take care,
Michael Simpson (916) 837-2211
Sac City Plumbing
3031 E St.
Sacramento, CA 95816
>
>From: Bill Mosca <wrmosca@comcast.net>
>To: MS_Access_Professionals@yahoogroups.com
>Sent: Fri, May 20, 2011 12:52:08 PM
>Subject: [MS_AccessPros] Re: Inspection Structure
>
>
>Art
>
>You shouldn't need a separate table for each room. You would have one table with
>a UnitInspectionID (to get the unit info/date/etc.), RoomID, inspection point
>(i.e. Floor, ceiling, wall, etc.), condition.
>
>So you have an inspection of Unit #123. You go into the Entryway and mark the
>floor's condition as poor.
>
>Wouldn't that cover it?
>
>Regards,
>Bill Mosca, Founder - MS_Access_Professionals
>http://www.thatlldoit.com
>Microsoft Office Access MVP
>https://mvp.support.microsoft.com/profile/Bill.Mosca
>
>--- In MS_Access_Professionals@yahoogroups.com, "Art" <dbalorenzini@...> wrote:
>>
>> I am struggling setting up a table structure for a house inspection database.
>>
>> I have it setup like this but it does not seems to be right
>>
>> tblUnitInspection
>> UNitInspectionID PK
>> UnitID
>> InspectionDate
>> TenantTypeID
>> TentPresentFlag
>>
>> Now in the inspection form has each room in the house broken out
>>
>> Entryway, Kitchen, Dining room, Living room,Hallway, Bathroom #1, Bathroom #2,
>>Attic, Bedroom #1, Bedroom #2, Bedroom #3, Bedroom #4, Utility room,Stairwell,
>>Basement, Exterior.
>>
>> I am looking at putting each room in it seperate table (eg. tblUnitEntryway)
>>
>> tblUnitEntryway
>> UnitEntrywayID PK
>> UnitInspectionID
>> FloorsCleanConditionTypeID - Lookup table tlkpCleanCondtionType
>> FloorsTypeID - Lookup table tlkpFloorType
>> FloorConditionTypeID - This is my issue, this is a key to the
>>tlkpConditionType table but I found out that they can select mulitple items. So
>>I know multi- value fields are bad so I am not sure what to do.
>> FloorRepairsDesc - text
>> WallCleanConditionTypeId - Lookup table tlkpCleanCondtionType
>> WallConditionTypeID - same issue as above.
>> WallRepairsDesc - Text
>> CeilingCleanConditionTypeId - Lookup table tlkpCleanCondtionType
>> CeilingConditionTypeID - same issue as above.
>> CeilingRepairsDesc - Text
>>
>> And so forth and so on. I was think I could put the Floor, Wall, Ceiling into
>>seperate tables that will make for a whole bunch of table I don't think I need.
>>Any ideas?
>>
>> Thank you,
>>
>> Art Lorenzini
>> Sioux Falls, SD
>>
>
>
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar