Creating Lookups

In Microsoft Dynamics NAV, you can copy data from one table to another by creating a lookup in a field.  You can do the same in your Web Parts in Employee Portal.

But first you must make sure that the following tasks are completed for both the Web Part Request that you want to create a lookup from and the Web Part Request that you are targeting:

Preconditions

• Creating Web Part Request Templates

• Creating Employee Portal Groups

• Creating Web Part Requests

• Defining Tabs

• Adding Fields to Web Parts

You can get an overview of all the tasks you need to complete to create a Web Part here: Creating Web Parts for Employee Portal.

To Create a Lookup for a Field

1. Open the EP Web Part Request Card window.

2. Select the Web Part Request you want to make the look up from. Select the relevant table.

3. Click Table, Card. The Table window is opened. Select the relevant tab.

4. Click Tab, Card. The EP WP Table Tab window appears. Select the field from which you want to make a lookup.

5. Click Field, Lookups. The EP WP Field Lookup List window is opened.

6. Fill in the fields. For Help about a specific field, click the field and press F1.

7. Click Lookup, Conditions. The EP WP Lookup Field Conditions window is opened. Fill in the fields.

8. Click Lookup, Field Mappings. The EP WP Lookup Field Mapping window is opened. Define the target and source fields.

Related Topics

Multilanguage in Employee Portal

Adding Fields to Web Parts

Web Part Requests

• Перевести на английский