Like standard datasheets, access to records displayed using master/detail datasheets is controlled by family-level security privileges. But because a master/detail datasheet displays records belonging to two entity families that are related to one another through a relationship family, the security considerations for master-detail datasheets are somewhat more complex. Specifically:
To access records in a master/detail datasheet, at least View privileges are required on the master family. Even if users have privileges on the detail family, without privileges on the master family, they will not be able to access records that are displayed in master/detail datasheets.
To view existing detail records, users must have View privileges on the detail family and the relationship family that relates the master family to the detail family.
To create new detail records in a master/detail datasheet, users must have View, Insert, and Update privileges on the detail family.
In addition to family-level privileges, the ability to manage records in master/detail datasheets is controlled by datasheet-level privileges. You can define datasheet-level privileges on the Create New Master Form window, which appears when you create a master/detail datasheet.
Five datasheet-level permissions options are available, which control the ability to manage detail records in a master/detail datasheet:
Allow for Deletion: Determines whether users will be allowed to delete detail records.
When this check box is selected, users with Delete privileges on the detail family will be allowed to delete detail records.
When this check box is cleared, users with Delete privileges on the detail family will not be allowed to delete detail records.
Regardless of whether this check box is selected or cleared, users without Delete privileges on the detail family will not be allowed to delete detail records.
Allow for Insertion: Determines whether users will be allowed to create detail records.
When this check box is selected, users with Insert privileges on the detail family will be allowed to create detail records.
When this check box is cleared, users with Insert privileges on the detail family will not be allowed to create detail records.
Regardless of whether this check box is selected or cleared, users without Insert privileges on the detail family will not be allowed to create detail records.
Allow for Editing: Determines whether users will be allowed to modify detail records.
When this check box is selected, users with Update privileges on the detail family will be allowed to modify detail records.
When this check box is cleared, users with Update privileges on the detail family will not be allowed to modify detail records.
Regardless of whether this check box is selected or cleared, users without Update privileges on the detail family will not be allowed to modify detail records.
Allow for Linking: Determines whether users will be allowed to link new detail records to the master record.
When this check box is selected, users will be allowed to link detail records to the master record if they have Insert privileges on the relationship family that relates the detail family to the master family.
When this check box is cleared, users will not be allowed to link detail records to the master record even if they have Insert privileges on the relationship family that relates the detail family to the master family.
Regardless of whether this check box is selected or cleared, users without Insert privileges on the relationship family that relates the detail family to the master family will not be allowed to link detail records to the master record.
Allow for Unlinking: Determines whether users will be allowed to unlink existing detail records from the master record.
When this check box is selected, users will be allowed to unlink detail records from the master record if they have Delete privileges on the relationship family that relates the detail family to the master family.
Note: To unlink the detail records from the master record, you must select the Allow For Deletion and Allow For Unlinking check boxes.
When this check box is cleared, users will not be allowed to unlink detail records from the master record even if they have Delete privileges on the relationship family that relates the detail family to the master family.
Regardless of whether this check box is selected or cleared, users without Delete privileges on the relationship family that relates the detail family to the master family will not be allowed to unlink detail records from the master record.
