Select your table or query
Tables, Queries, or Both.
2. Click to select the table or query you want.
3. Click Next. The Lookup Wizard moves to the next page.
Select fields
You choose the fields you want to appear in your lookup column. Be sure to include the primary key.
1. Click the field you want.
2. Click the single right-arrowbutton . Access places the field in the Selected Fields column. Repeat this process to select additional fields. If you want all the fields in the table, click the double
right-arrow button . Note: Usethe single left-arrow and the double left-arrows to deselect fields.
3. Click Next. The Lookup Wizard moves to the next page. You choose the fields you want to appear in your lookup column. Be sure to include the primary key.
Sort fields
The Lookup Wizard allows you to sort the records in a lookup column. You can display records in order, either ascending (alphabetical from A to Z, lowest number to highest number, earliest date to latest date) or descending (alphabetical from Z to A, highest number to lowest number, latest date to earliest date). You can also sort within a sort. For example, you can sort by state and then within each state by city, and then within each city by street address. If you are creating a sort within a sort, create the highest level sort on line one, the next level sort on line two, and so on. In the state, city, and street address example, you create the state on line one, the city on line two, and the street address on line three.
1. Click the down-arrow and then select the field you want to sort by.
2. Click to select a sort direction (the button toggles between ascending and descending). You can sort within a sort for up to four levels.
3. Click Next. The Lookup Wizard moves to the next page.
Post a Comment