Looking up a value in an other table.
Move the cursor to the field you want to complete.
Press * or double-click with the left mouse
If the field refers to another table, that table appears on screen to
allow you to select the value you want to use.
Highlight the row you want to use.
Press Ctrl + Enter or double-click on the row.
The chosen value is copied to the column.