Not quite because the rooms inspection point condition can have multiple values (eg. Wall Condition type: Water spots, paint chipped, holes )
With warm regards,
Arthur Lorenzini| SQL Server/Access Developer l alorenzin@live.com
Office: 605-338-0947| Mobile: 605-857-9137 | Fax: 605-338-0947
1316 E. 7th Street
Sioux Falls, SD 57103
SQL Server Development
Database Adminstration Services
Microsoft Access Development
Grant Writing TA Services
IT Assessment Services
Software Application Training
From: Bill Mosca <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, May 20, 2011 2:52 PM
Subject: [MS_AccessPros] Re: Inspection Structure
ArtYou 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_Professionalshttp://www.thatlldoit.comMicrosoft Office Access MVPhttps://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