You use this procedure to import lookup table data.
-
Select File > New > Lookup Table Link .
-
In the Lookup Table Link Wizard, on the Define the Lookup Table Link Name page, under Link, type the link name.
-
Under Description, type a brief description of the link if needed.
-
Select Next.
-
On the Source and Target Definition page, from the Source table list, select a source table.
OR
Select Use query and then select the query you require from the list. Select New query if you need to define a new query.
-
Select Data Source to preview and edit the contents of the source table or the tables defined in the selected query. You cannot edit the data if you are previewing tables defined in a query.
-
Select Filter to define a filter condition if you want to include only specific source items from the selected table or the tables defined in the selected query. You can use the following wildcard characters in your filter: % - any combination of characters. _ (underscore) - any single character
-
Under Target, from the Lookup table item type list, select a lookup table item type.
-
From the Lookup table item list, select a target lookup table item.
-
Select Next.
-
On the Map the Lookup Table Fields page, select a source field from the Source pane and drag it to a Source Field box in the Target pane.
-
You can select Data Source and View Data to preview the contents of the source and target tables.
-
Select Expand to view the page in full screen mode. Select Expand again, to continue and return the page to normal-size mode. You can only continue to the next page when the page is in normal-size mode.
-
-
Select Next.
-
On the Completing the Lookup Table Link Wizard page, select View to examine the lookup table link summary information.
-
Select Finish to create the link.