Chapter 1-3: Data Dictionary

Record Protection Fields

Record protection fields instruct APPX to verify whether or not a user is allowed to delete a record or change a primary key value in a record. Use of these fields allows you to maintain referential integrity within an application.

·     Delete Protection fields govern whether or not a user can delete a record while executing an input process. These fields can be used to prevent the creation of “orphan” records, by prohibiting the deletion of any record that is referenced by other records in the application.

·     Key Protection fields govern whether or not a user can modify the primary key to a record while executing an input process. These fields can be used to prohibit modification of primary keys that are referenced by other records, thus also preventing “orphan” records.

·     Record Access fields contain designer-designated security codes that automatically restrict the ability to retrieve a record (and by implication any field on the record) to users with security profiles that include this code. If a user does not have access to the record, APPX responds as if the record is not on file. The designer must maintain the values in this type of field.

APPX Application Design Manual (01/13/03)

© 2003 by APPX Software, Inc. All rights reserved