Creating the Lookups

You will now create lookup lists for most of the tables you have just created. Using the Lookup Wizard, this task should be quick, even for five lookup lists.

Verify that Order Entry Tutorial is still set as the current workspace in the Studio.

Following the same techniques described in Creating a Lookup List in Quick Start, create the five lookups as shown below.

Customer List

Create a Customer lookup list using the following parameters:

• Data Dictionary: Customer_DataDictionary
• Object Name: Customer_sl
• File Name: Customer
• Description: Customer Lookup List

Add the following columns to the list:

• Customer_Number
• Name

Sales Persons List

Create a Sales Persons lookup list using the following parameters:

• Data Dictionary: SalesPerson_DataDictionary
• Object Name: SalesPerson_sl
• File Name: SalesPerson
• Description: Sales Person Lookup List

Add the following columns to the list:

• Id
• Name

Vendor List

Create a Vendor lookup list using the following parameters:

• Data Dictionary: Vendor_DataDictionary
• Object Name: Vendor_sl
• File Name: Vendor
• Description: Vendor List

Add the following columns to the list:

• Id
• Name

Inventory List

Create an Inventory lookup list using the following parameters:

• Data Dictionary: Inventory_DataDictionary
• Object Name: Inventory_sl
• File Name: Inventory
• Description: Inventory Lookup List

Add the following columns to the list:

• Item_Id
• Description
• Unit_Price
• On_Hand

Orders List

Create an Orders lookup list using the following parameters:

• Data Dictionary: OrderHeader_DataDictionary
• Object Name: OrderHeader_sl
• File Name: OrderHeader
• Description: Orders Lookup List

Add the following columns to the list:

• Order_Number
• Customer.Customer_Number
• Customer.Name
• Order_Date
• Order_Total

Next Step

Creating the Views