Managing Data with Microsoft® Excel

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 ...