| re: Database design
Hi Joanna,
Might something like this work?
[color=blue]
> tblHomes
> HomeID (Autonumber)
> Address
> ScheduledStartDate
> ScheduledPunchDate
> ScheduledFinalDate
>
> tblInspections
> InspectionID (Autonumber)
> HomeID (Foreign key to tblHomes)
> InspectionDate
> InspectionBy (Lookup tblEmployees)
> InspectionType (Punch, Final)[/color]
InspectionSubType (Final-failed, Final-with exception, Final-no
exception)
Assuming multiple rooms are inspected during each inspection then you have:
tblInspectionsDetail
InspectionDetailID (Autonumber)
InspectionID (Foreign key to tblInspections)[color=blue]
> InspectionRoom
> InspectionDetails[/color]
HTH -Linda
"Joanna" <mellnorr@peoplepc.com> wrote in message
news:7e16225c.0409181820.5e475cc@posting.google.co m...[color=blue]
> I am developing a database to track inspections conducted on homes. I
> have two main types of inspections, Punch & Final; however Final
> inspections have 3 possible sub-categories: failed, with exception, no
> exception. Each home will always have one Punch inspection; however
> there can be many types of final inspections. Each final inspection
> could have outstanding items from previous inspections but more items
> could be added.
> I am having difficulty getting the forms & getting the data to relate
> properly.I feel like a "Completed" field could be used but I'm not
> sure how it will help.
>
> I originally designed on paper the following for the database:
>
>
> tblHomes
> AddressID (Autonumber)
> Address
> ScheduledStartDate
> ScheduledPunchDate
> ScheduledFinalDate
>
> tblInspections
> InspectionID (Autonumber)
> InspectionType (Punch, Final Attempted, Final with Exceptions, Final
> No Exceptions)
> HouseID (Lookup from tblHomes)
> InspectionDate
> InspectionBy (Lookup tblEmployees)
>
> I then thought I would need an Inspection Details table with the
> following:
>
> InspectionDetailID (Autonum)
> InspectionID (lookup from tblInspection)
> InspectionRoom
> InspectionDetails
>
> It's not working & I'm hoping someone could either expand on my idea
> or suggest a more logical way to set up the database within access.
>
> Thanks in advance![/color]
| 
