Lookup Registry entry

Specify permissions for fields with a Lookup List.

Usage

This Registry entry can be assigned to users and groups:

Key	User	User	Group	Group	Group	Group
Key 1	`User`	`User`	`Group`	`Group`	`Group`	`Group`
Key 2	user	user	group	group	`Default`	`Default`
Key 3	`Table`	`Table`	`Table`	`Table`	`Table`	`Table`
Key 4	table	`Default`	table	`Default`	table	`Default`
Key 5	`Lookup`
Key 6	column or `Default`
Value	permission

In pipe-delimited format:

`User`	user	`Table`	table	`Lookup`	column	permission
`User`	user	`Table`	`Default`	`Lookup`	column	permission
`Group`	group	`Table`	table	`Lookup`	column	permission
`Group`	group	`Table`	`Default`	`Lookup`	column	permission
`Group`	`Default`	`Table`	table	`Lookup`	column	permission
`Group`	`Default`	`Table`	`Default`	`Lookup`	column	permission
`User`	user	`Table`	table	`Lookup`	`Default`	permission
`User`	user	`Table`	`Default`	`Lookup`	`Default`	permission
`Group`	group	`Table`	table	`Lookup`	`Default`	permission
`Group`	group	`Table`	`Default`	`Lookup`	`Default`	permission
`Group`	`Default`	`Table`	table	`Lookup`	`Default`	permission
`Group`	`Default`	`Table`	`Default`	`Lookup`	`Default`	permission

where:

column

is the back-end column name of a Lookup List field; or use Default to apply permission to all Lookup Lists in the table(s) specified in Key 4.

permission

can be:

`ReadOnly`	Users can only select an existing value from the Lookup List. New values cannot be entered into the field. A message similar to the following will display if a user tries to save a record with a new value in the Lookup List:
`Skip`	An entry will not be checked against the Lookup List and will not be added to the Lookup List. If the column with `Skip` enabled is part of a hierarchy, its level of the hierarchy is skipped. For example: we have a Lookup List called Location with a hierarchy of Country >State >City If a new entry of Australia > Victoria > Melbourne is added, then three records would typically be added to the Location Lookup List: Australia Australia > Victoria Australia > Victoria > Melbourne If `Skip` is enabled for the State column, then entries with Country, State and City will be created, but entries with just Country and State will be skipped. In this example, two records would be created in the Location Lookup List: Australia Australia > `Victoria` > `Melbourne`
`ReadIgnore`	If a new value is entered into the field, a warning will display when the record is saved that the Lookup List is `ReadOnly`. The user has the option to add the value anyway by selecting Ignore; the value is added to the Lookup List but the Hidden flag is set to Yes. A message similar to the following will display if a user tries to save a record with a new value in the Lookup List: Note: The Insert Lookup Show Hidden Registry entry and Query Lookup Show Hidden Registry entry can be used to override this Hidden setting.
`ReadWrite`	If a new value is entered into the field, the user will be asked to confirm insertion of the value into the Lookup List when the record is saved. A message similar to the following will display if a user tries to save a record with a new value in the Lookup List:
`WriteIgnore`	When the record is saved, a user will have the option to add (or not to add) a new value to the Lookup List or to select Ignore to add the value and set the Hidden flag to Yes. A message similar to the following will display if a user tries to save a record with a new value in the Lookup List: Note: The Insert Lookup Show Hidden Registry entry and Query Lookup Show Hidden Registry entry can be used to override this Hidden setting.
`AutoWrite`	A new value will be added to the Lookup List without prompting the user.
`AutoWriteIgnore`	Combines `AutoWrite` and WriteIgnore: a new value is automatically added to the Lookup List and the Hidden flag is set to Yes.

Note: The Lookup Registry entry may be set at the field, table, group, or user level, and defaults to ReadWrite.

Note: Read on for details about how Lookup List permissions set in the Registry are processed by lutserver.

Examples

No values may be used that do not already exist in the Lookup List associated with the RecordStatus column in any table:

Key	Setting
Key 1	`Group`
Key 2	`Default`
Key 3	`Table`
Key 4	`Default`
Key 5	`Lookup`
Key 6	`RecordStatus`
Value	`ReadOnly`

The System default for any Lookup table is ReadWrite unless overwritten by a higher level Registry entry:

Key	Setting
Key 1	`Group`
Key 2	`Default`
Key 3	`Table`
Key 4	`Default`
Key 5	`Lookup`
Key 6	`Default`
Value	`ReadWrite`

Note: It is possible to make an individual level of a field hierarchy read-only, while the remainder of the levels below it can be updated (read-write). For example, in the Parties module, it is possible to allow users to add new cities but not states / provinces or county names.