Locking a Layout
I have a rather complex layout used for product specification entry including several portals to related tables.
One tab on this layout is called "Authorizations" and it consists of four sets of radio buttons and three text fields. The first set is simply Locked or Unlocked. The other three sets are keyed to specific users where they either Approve or Not Approve the spec. If they choose not to approve the spec, a text box appears where they enter the reason for the disapproval.
When the spec writer clicks "Locked" I would like all the entry fields to be locked EXCEPT for the fields on the Authorization tab.
Currently all the authorization fields are in the "master" specification table. I'm thinking they may be better located in their own related table, but don't know where to start on locked all the other records.