RELATIONAL FIELDS:

Relational field: code = R

Relational fields are just fields that link to a corresponding
field in a different dBworxPE file.  Let's say you have a sales order
file and there is a field in that file named "Item No." and another
one named "Item Description".  You want to enter the item number
for each record, then have dBworx go get the item description from
a different file (which must also have fields named "Item No." and
"Item Description"). 

When you create the sales order file, you would enter an "R" under
'Field Type' for the Item Description field.  At that point dBworxPE
displays a pop-up screen asking for the name of the file you want 
to link to.  After you click on the file you want, another screen 
appears asking you to enter the name of the field you want to use
as a 'key'.  

In this case you would enter "Item No."  The key field MUST be a
field that's included in both the current file and the linked file
and the field description must be exactly the same in both files. 

While you're entering sales order records, when you get to the Item
Description field dBworxPE will use the key field's value (the item
number) to locate a corresponding record (a record with the same
item number) in the linked file.  Then dBworxPE will take the item
description from that record in the linked file and plug it into
"Item Description" in the sales order record.