Sybase Desktop Creating a lookup field in a Lotus Notes database, Creating a lookup field mapping

Implementing on-device database lookups

Creating a lookup field in a Lotus Notes database

When creating a lookup mapping, there are always two databases involved: the current database and the lookup database. In the example below, “Order” is the current database and “Customer” is the lookup database.

FigureE-1Creating a lookup field

You can create a lookup field mapping by referencing within a local database form a column within a view of the lookup database. In Pylon Pro, this field is called a lookup field. It is created when you add a specific type of Dialog list field to a Lotus Notes design. In the example above, idnumber is the lookup field.

Creating a lookup field mapping

To create a lookup field mapping:

1.Create a new field in a form and set the field Type to Dialog list.

2.In the Field designer, click the Control tab.

Desktop User Guide for Pylon Conduit and Pylon Pro, Version 5.4 / 211