A look up is one of the names given to a field that has a restricted selection. Restricted selection allows users to increase the speed of input and allow more consistency over values entered on mobile devices and it allows improved validation of values being entered or edited into fields on all devices. The CASK Inventory Database attempts to make these lookups definable by administrators through the SYS ADMIN menu.
Each lookup references a table and should be identifiable in the list tables as it has a prefix of LK followed by a unique number. Information is stored in database tables as text but referenced in the drop down to these tables. Accessing the raw table through this menu allows the selected users to alter the values than can input or edited by users using the add new or edit button record buttons. To assist administrators columns that reference lookup tables are listed with their reference table number. Below is a screen shot of the of the columns that are referenced to lookups in the cask fill screen. NOTE this should not affect the import feature of the database and any values should be accepted providing they are of the correct variable type.
If we got into the cask size lookup through the sysadmin menu LK004 cask size we will see all the sizes that are available in the drop down for data entry and data edit.
This allows administrators to control what is input and facilitiates mobile input as on mobile devices a special selector modal appears on the screen or add on edit of the field listing the created options. Don’t worry about the include field at present the plan is in the future to restrict the modal to only those that are include for more rapid mobile input.
