valid entry or not. (ii) Look up : The look up feature is used by a field to find its values in another table, query or from a fixed list of values. A list of valid values can be displayed using a list box or combo box. Text box is the default display control of look up.
Look up is created in case of a field, which is foreign key (many side) into primary key (one side) between the tables that have one-to-many relationship. Its other display controls are list control and combo control. When list box or combo box is used as display control in look up, it is important to specify the row source type (that is table, query or list of values or field list). The list of values must be separated by comma.
Some additional properties in case of list box or combo box are meant to specify the bound column whose values are copied to this field as references. Number of columns to appear in the list box or combo box is determined by column count property. The above steps for defining a column need be repeated for every column to be created for a particular table. After defining all the columns of the table, the primary key column of the table can be specified as any of the columns that are expected to have unique data values.
This can be achieved by right clicking at the field to be specified as primary key followed by primary key item of right clicked window. If more than one field constitutes a primary key, select first field (of such composite primary key) by pressing and holding Ctrl key and clicking other fields (of the composite primary key) one by one in the same order in which they together constitute the primary key. This must be followed by right click at selected fields to mark the selected fields as primary key. Save the table design by clicking at File item of menu bar followed by click at Save option.
Access responds by providing a generic default name