Lookup
Symbol 
Fetches a value from a detail table that can create a reference to the source table and enters this value in the target.
Lookups can be nested as required.
'Input help' area
Source alias
This is the database alias for the data source specified in the main node (transfer).
Changes made here will be reflected in the Transfer main node.
Target alias
The database alias in the main node (Transfer) for the target is shown here.
Changes made here will be reflected in the Transfer main node.
'Lookup' area
Find source value
Enter here the field in the source data where the value to be checked by the Lookup is located.
In database
This selection allows you to specify if the source database refers to the Source or the Target.
Depending on this selection, the Table name field will display the tables for the Source alias or the Target alias for selection.
In table name
Select a table here that is to be linked to (detail table).
The tables available for selection will depend on whether Source or Target was selected in the In database field.
If you type in the table name instead of selecting it from the list, make sure you enter the characters with the correct case (upper or lower case).
In field
Select here the field in the detail table through which the reference is to be created.
Deliver
Select the field in the detail table the value of which is to be transferred to the target (variable / field).
The Lookup node in the Transfer tree also contains a Default sub branch.
Here you can define an action to be performed if no Lookup data set is found.
Fixed target
The Target area is displayed if you activate this option.
In the Target area, you can assign the value from the Lookup to a variable or transfer it to a field in the Target alias.
'Target' area
Overwrite font
This option can only be set when the target field type is Long text (RichText).
The button is used to 
define the font to be used in the target field.
You can use this option to change the font if the source table is also the target table.
Also see Transfer - Change item fonts
Variable
Activate the Variable option if the value from the function is to be written in a variable.
When Long text (RichText) fields are transferred, the button can also be used to change the font.
Also see Transfer - Change item fonts
Variable
Enter a unique name for the variable. You can also use variables that are already used in the transfer. You can specify if the value of the variable is replaced or the new value is appended using the Mode.
Mode
The Mode determines whether the value in the variable is to be overwritten or the new value appended after the existing value.
Set
The value of the variable is overwritten.
Concat
The newly determined value is appended after the existing value of the variable (concatenated).
Field
Activate this option if the value from the function is to be transferred to a field.
Table
Select a table. The tables from the target alias are listed here for selection.
Variable
The corresponding fields from the selected table are shown here for selection.
The values of the function are transferred into this field.
Field type / Field length
These values are taken from the database information as far as possible.
They can be manually edited if required for undefined types and lengths.
In the example, the contact person number (ContPersNo) is required when recording an additional telephone number (ANSPTEL table). This is not present in the source data because a ContPersNo was drawn from the number groups when the contact person was created.
When the contact person was created, an internal ID (Number field) was written in the Palmid field in the contact person data set. This auxiliary number can be used to create a correlation between contact persons and telephone numbers when the contact person telephone numbers are imported separately.