I uploaded the structure to the needs assistance folder. Maybe someone can take a look at what I got so far cause I am getting myself confused.
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 4:50 PM
Subject: [MS_AccessPros] Re: Inspection Structure
Then you need to add another row for that inspection of that unit in that room for that part of the room.
It's kinda like taking inventory of a room with shelves that contain multiple products.
Bill
--- In MS_Access_Professionals@yahoogroups.com, Art Lorenzini <dbalorenzini@...> wrote:
>
> 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@...
> 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@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Friday, May 20, 2011 2:52 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]
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar