To change the design of the multivalued field, set it's Lookup properties.Ĭlick the lookup field's name in the Field Name column. When you use the Lookup Wizard to create a lookup field, the Lookup field properties are set for you. Top of Page Update the properties of a lookup field In the following example of the AssignedTo lookup field:Ģ The employee ID is the bound value, which is stored in the Bound Column property of the Lookup field properties. However, the bound value is what is stored, what you use in query criteria, and what Access uses by default in joins with other tables. The display value is automatically shown in Datasheet view, by default. It is important to understand the distinction between a lookup field's display value and its bound value. It is automatically looked up in a source table or query and replaced with the contact name. The contact ID number is the bound value. For example, instead of displaying a contact ID number, Access can display a contact name. The purpose of a lookup field is to replace the display of a number such as an ID with something more meaningful, such as a name. Top of Page Understanding the bound and display values On the sixth page, keep the field name or enter a new one, select Enable Data Integrity, choose a Cascade Delete or Restrict Delete option, and then click Finish.įor more information about enforcing referential integrity, see Create, edit or delete a relationship. On the fifth page, adjust the width of the column to make the values easier to read, and then click Next. On the fourth page, select a sort order for the fields when displayed in a list, and then click Next. On the third page, select one or more fields, and then click Next. On the second page, select the table or query that contains the values, and then click Next. On the first page, select I want the lookup field to get values from another table or query, and then click Next. Note The Lookup Wizard creates three types of lists depending on the choices you make in the wizard: a lookup field, a values list field, and a multivalued field.Ĭarefully follow these steps in the wizard: In the first available empty row, click a cell in the Field Name column, and then type a field name for the lookup field.Ĭlick in the Data Type column for that row, click the arrow and then, in the drop-down list, select Lookup Wizard. Top of Page Create a lookup field in Design View The Lookup Wizard simplifies the process and automatically populates the appropriate field properties and creates the appropriate table relationships. Whenever possible, you should use the Lookup Wizard to create a lookup field. Understanding the bound and display valuesĪ lookup field is a field in a table whose value is retrieved from another table or query. For more information, see Create or delete a values list field and Create or delete a multivalued field. Note Access has other types of list fields: a values list field that stores only one value with valid values defined in a property and a multivalued field that can store up to 100 values in one field, separated by a comma (,). Then, when you select the customer in that control, an appropriate value - such as the customer's primary key value - is stored in the order record. You can create a lookup field that displays the customer information in a combo box or list box control. However, all customer information is tracked in the Customers table. For example, you want to record the customer for an order in the Orders table. A lookup field can display a user friendly value that is bound to another value in the source data table. Header Footer Sections report this ad Werbung report this ad Lesson 6 Creating mailing labels Objective Use the Label Wizard to create mailing labels.Creating a lookup field not only improves the meaning of data but helps avoid data entry errors by limiting the values that can be entered.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |