In the case of combo boxes, users can select one entry from the list entries or enter text themselves. On the Field links page the Wizard will ask you about all the settings required for this link. If an article table contains, for example, the number of a supplier, the list box can use the "Supplier number" link to display the name of the supplier from the supplier table. When list fields contain linked columns, the first column of the other table will be used without a query being shown first. If the field name is not found, the list will remain empty. In the other tables the required field is searched for by using the field names (ControlSource) and then the fields will be completed accordingly. Thus the List Box Wizard allows two tables of a database to be linked, so that the control field can display a detailed list of a database field that is located in a different table from the one to which the form refers. Through reference values, list boxes can display data from a table linked to the current form table. The list boxes in a form work by using references that is, references to the visible list entries are located in the form table (values table) and are also entered as such in the values table if the user selects an entry from the list and saves it. These entries are saved in a database table and cannot be modified through the list box.Īs a general rule, the database table that contains the visible list entries in the form is not the table on which the form is based. In the case of a list box, the user selects one entry from a list of entries. This is because the nature of control fields: The wizards for combo boxes and list boxes differ from each other in their final step. You can use the Wizards On/Off icon to keep the wizard from starting automatically.
0 kommentar(er)
