Once we've done that we can go and create our lookup itself. Open up the data Pump and move to the fourth tab (Lookups). This will only be available in SQL Server 2000. For those of us using SQL Server 7 move to the last tab and about half way down on the right hand side is a little button marked Lookups.

Figure 1.2 Creating the Lookup

In SQL Server 2000 you can simply start entering the details. In SQL Server 7 though you need to press Add