[MS_AccessPros] Inspection Structure

 

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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 5
• New Files 2

Visit Your Group

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

---

Get great advice about dogs and cats. Visit the Dog & Cat Answers Center.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___