Consider the following scenario:
| You import a Microsoft Windows SharePoint Services list into a Microsoft Office Access 2007 database table. |
| You click to select the Import display values instead of IDs for fields that look up values stored in another list check box when you import the Windows SharePoint Services list. |
A Windows SharePoint Services list contains at least one multivalue lookup column.
Note The multivalue lookup column looks up values that are stored in another Windows SharePoint Services list. |
In this scenario, when you view the imported Windows SharePoint Services list in the table datasheet view, the multivalue lookup column displays ID numbers. However, the column does not display the display values.
To work around this behavior, you can import the following two Windows SharePoint Services lists into Access 2007 at the same time:
| The Windows SharePoint Services list that contains the multivalue lookup column |
| The Windows SharePoint Services list that the multivalue lookup column uses to look up data |
To do this, follow these steps:
| 1. | Start Access 2007. |
| 2. | Click the Microsoft Office Button, and then click Open. |
| 3. | Locate the database that you want to open, and then click Open. |
| 4. | On the External Data tab, click SharePoint List in the Import group. |
| 5. | Type the SharePoint site name, click Import the source data into a new table in the current database, and then click Next. |
| 6. | In the Import column, click the name of the Windows SharePoint Services list that contains the multivalue lookup column. |
| 7. | In the Import column, click the name of the Windows SharePoint Services list that the multivalue lookup column uses to look up data. |
| 8. | Click to select the Import display values instead of IDs for fields that look up values stored in another list check box, and then click OK. |
| 9. | Click Close. |
| 10. | Open the imported table in datasheet view. Notice that the multivalue lookup column displays the display values. |
This behavior is by design.
