LOOKUP FIELDS:

Lookup field: code = L

A lookup field allows the user to pick a value for that field from
a pop-up list. The pop-up list is just a dBworxPE file (that you 
create) which contains only those field values that you want to
include in the lookup list (see the "lookup" example).

For instance, let's say you have an inventory order file where each
record contains an item description and you want to get that
description from a separate dBworx file you've created named 
"itemdesc.dwh".  In order to do that, in designing your inventory
order file you would enter an "L" under "field type" for the item
description field -- then dBworxPE would display an "Open file"
dialog and you would select "itemdesc.dwh" as the lookup file. 

If you're keying an actual order, when you get to the item 
description field dBworxPE will pop up a window showing the records
in the "itemdesc" file and you can simply click on the record which
has the correct description.  NOTE: the field heading for the item
description field in the inventory order file must match the heading
for the description field in the "itemdesc" file (dBworxPE compares 
the two headings in order to pick the proper field value to return).

As a rule the lookup file itself will only consist of two or three
fields.  In this case "itemdesc.dwh" would probably contain just
"Item number" and "Item description", and you would click on the
record in the pop-up list that goes with the item number you 
entered.