Locking Inspection Notes

A feature that carried over from ZonePro 32 to ZP SQL is the option to Lock Notes in the Global Personalization section. This option locks the second Notes field in the selected database screens. The idea being that inspectors could move their notes to the second Notes field without worrying that they could be altered by someone else. The problem with this feature in ZP SQL is that the Building databases no longer store inspection notes in the main Notes fields. Each inspection detail entry has its own Notes field. So now I have extended the Lock Notes option for the Building databases. It now locks the Notes field in the Building Inspection Details screen, but only if the current user does not match up with the initials of the Inspector field for that detail. The original inspector can continue to make changes to that Notes field. The Result field and Inspector field are also locked, but only if the fields already have a valued entered in them, and again, only if the current user is not the original inspector.