BASICS:


dBworxPE is designed to handle structured data
such as inventory items, name and address
records, journal entries, and so on. 

For example, if you wanted to start a file of
contact records you would select to create a
new file; dBworxPE would then display the "design" screen, where 
you would specify what fields you wanted in your contact database
-- including the field descriptions, types, sizes, etc. 

Once you've defined the file structure and accepted it, you can
begin building your contact data from the data entry screen. 

To design a new database file, you click on the "Create New File"
button (or select "Create New File" from the "File" menu).  dBworxPE
will display the database design screen:



You add each field by selecting to "Append" (if you want to add the
next field after the ones already created) or "Insert" (if you need to
add a field between ones already created).  Once you've selected to 
append or insert you would enter the information in the "Current 
Record" box -- the field description (e.g., "Customer Name"), the 
type code ("A", "C", "N3", etc.), maximum field size, total flag 
(indicates whether or not you want to keep a numeric total for that
field), field value (used primarily for formula fields), the "must
enter" flag (indicates whether the user has to enter a value for that
field during record entry), "help text" (for that particular field), 
and a "check for duplicate entry" flag.

If you enter "Y" for the "Check for dups" flag, then every time you
enter a value in that particular field dBworxPE will scan through 
all entries on file to see if that same value has already been input
for that field in another record.  If a match is found, a "duplicate
entry" message will display and you can select to reenter the field 
or accept the duplicate entry.  This type of check can be useful 
when inputting serial numbers, order numbers, etc.

If you enter "help text" for a given field (e.g., an explanation
of what set of values are valid for that field, etc.), then during 
data entry the user can click on that field in the "current record" 
listbox on the left side of the screen and click on the "Field help"
button to display your help text.

If you want to write a program of your own in JustBASIC to do some
sort of custom calculation or processing, you can specify a program
name under "JustBASIC program" for any given field and that program 
will run each time you exit that particular field.  For example, if
you look at the "sales" sample database you'll see that a JustBASIC 
program named "sales01" is set up to run each time the "sales amount" 
field is exited during data entry.  All that "sales01" does is calculate
the cost amount as 80% of whatever sales amount has been entered, 
but more elaborate programs can be used to do more complex 
processing.  If you do write your own "field edit" program of this
type, a "tokenized" (.TKN) version of your program must be located 
in the directory where you installed JustBASIC.

NOTE:
You can move fields around (even after you've entered data into the 
database file) by clicking the "Move" button and selecting the field
to move (the "target" field) and a "destination" field.  The target field
will be moved to a position just BEFORE the destination field.