FIELD TYPES:

dBworxPE currently supports the following field types:

 Alphanumeric (code = "A"):
   An alphanumeric field can hold any combination of characters and
   numbers; it could be used for names, locations, formatted 
   numbers, etc.  Field capacity is 63,999 characters.

 Numeric (code = "N[0-9]"):
   Numeric fields are designated by an "N" which can be followed by
   an optional single digit specifying the number of decimal places
   for that field.  For example, a type code of "N3" would indicate
   a numeric field with three decimal places (such as 12.085).

 Currency (code = "C"):
   Currency fields contain monetary amounts and are automatically
   assumed to have two decimal places.

 Date (code = "D" or "D1" or "D2"):
   When a new record is entered, dBworxPE automatically fills a date
   field with the current date (mmddyyyy).  If you use code "D1"
   instead of "D", dBworx will format the date as yyyy/mm/dd; "D2"
   will format the date as "dd/mm/yyyy".

 Time (code = "T"):
   When a new record is entered, dBworx automatically fills a time
   field with the current time (hh:mm).

 Auto-increment (code = "I"):
   An auto-increment field is basically a counter; it adds 1 to the
   counter each time you add a record and assigns that number to
   the auto-increment field.

 Formula (code = "F[0-9]"):
   Formula fields allow you to fill a particular field with the
   result of a formula or calculation (see the section on formula
   fields under "Special field types").

 Static text (code = "S"):
   Descriptive text, such as headings.

 Memo (code = "M"):
   Memo fields can be used to hold large amounts of text (more 
   than the 63,999 characters allowed in regular alphanumeric 
   fields). Memo fields can accept plain or rich text but will
   save the memo entry as plain text. [NOTE: very large memo 
   entries do slow dBworxPE down to some extent when opening data
   files]. 

 External Field (code = "E"):
   External fields are links to some file, document or other 
   object on your PC.  You can use this field type to include
   spreadsheet files, web pages, bitmaps, pdf files or anything 
   else that has an application on your PC that is capable of 
   opening that particular type of object (e.g., Excel to open 
   Excel spreadsheet files or Acrobat Reader to open pdf files).

 Graphics (code = "G"):
   Graphics fields are created and edited using a built-in drawing
   program which allows the user to combine images, drawings 
   and text and store the result as a bitmap, JPEG or PNG graphic.

 Lookup List (code = "L"):
   Allows the user to select the field value from a pop-up list
   (see the "lookup" example).

 Relational (code = "R"):
   Pulls a field from another dBworxPE file into the current record.
   Look under "Special Field Types" for further information (also
   see the "timesheet" example).

 Subsidiary (code = "J"):
   Embeds additional fields within a dBworxPE field.  For instance,
   if you're setting up a purchase order file you need to store
   (as part of each record) the individual line items showing what
   was ordered.  You can define a field (called something like
   "Items ordered") and give it a field type of "J".  Once you've
   entered all your line items, dBworxPE will store them in the 
   "Items ordered" field as a single string. url(code = "u"):
   A URL field holds a web address such as "http://www.yahoo.com"
   or "www.plworx-software.com".  If you right-click on a URL 
   field, the built-in web browser will display and attempt to 
   navigate to the web address stored in that field.

 Email Address (code = "@"):
   This type of field is designed to hold email addresses (such 
   as jsmith@mymail.com).  If you press F4 or right-click on an
   email field, dBworxPE will open the default email client 
   program on your PC and insert the field contents in the "To"
   box of the "compose message" screen.

 Worx (code = "W"):
   Functions somewhat like a hyperlink; right-click on the value
   in this field (which will be the path to another dBworx file)
   and dBworxPE will open that file for updating.  Once the linked
   dBworxPE file is closed, the program will return to the original
   file.  (NOTE: This field type can be used to set up a dBworxPE
   file which acts as a menu for all your other dBworxPE data files
   - see the "menu" example).