• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Using Microsoft Query > Joining Parent and Child Records

Joining Parent and Child Records

The buildings discussed in the previous section are probably subject to municipal codes and other regulations that require the regular inspection of doors. Those regulations of course require you to correct any problems that are found. Outside doors need to work properly in emergencies. Doors separating hallways are often fire doors, and need to retard a fire's progress. Doors to closets often must be secure, especially if the closets might contain hazardous materials.

In turn, that means that each of those doors must be inspected regularly and a record made of its condition, including any maintenance action taken. Further, when an occupant of the building complains that, say, a bathroom door won't lock, that complaint needs to be recorded. So does the subsequent repair of the door. Complaints don't follow tidy schedules the way that regular maintenance does.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint