Piper's Pit BBS/FTP: ibm 0020 - 0029/ibm0020-0029/ibm0028.tar/ibm0028/NUT2-3.ZIP/TOUR4.SCR

Text File | 1990-10-22 | 21.8 KB | 866 lines

v 0
p '{home}{c-del}
f 0
a 6,14
b 2,1,24,80
l 2,'                    G U I D E D   T O U R   D E M O
l 4,'                Published by IRIS Software Products  tm
l 5,'                        Stoughton, Mass. 02072
l 8,'                         "Using lookup files"
l 12,'
l 13,'To load NUTSHELL PLUS II into your computer:   ┌────────────────────────┐
l 14,'                                               │ ┌──────────────────┐   │
l 15,'     1. At the DOS Prompt, type:  nutplus      │ │                  │ █ │
l 16,'                                               │ │                  │   │
l 17,'                                               │ │                  │   │
l 18,'                                               │ │                  │   │
l 19,'                                               │ │                  │ o │
l 20,'                                               │ │C>                │ o │
l 21,'                                               │ └──────────────────┘   │
l 22,'                                               └────────────────────────┘
v 1

w 0,'n
p '{right}
l 20,'                                               │ │C> n
w 0,'u
p '{right}
l 20,'                                               │ │C> nu
w 0,'t
p '{right}
l 20,'                                               │ │C> nut
w 0,'p
p '{right}
l 20,'                                               │ │C> nutp
w 0,'l
p '{right}
l 20,'                                               │ │C> nutpl
w 0,'u
p '{right}
l 20,'                                               │ │C> nutplu
w 0,'s
p '{right}
l 20,'                                               │ │C> nutplus
d 5
l 17,'     2. Now press the ──┘ key to enter
l 18,'        your command and load
l 19,'        NUTSHELL PLUS II.
w 0,'{ret}
b

a 14,15



p '{home}
b 11,31,9,49
l 1,'In this tour, we'll first open a file of
l 2,'names and addresses that an executive
l 3,'might keep.
l 4,'To use a file called NAMES:
l 6,'    1. Type:    names
w 1,'names
l 7,'    2. Press the ──┘ key.
w 0,'{ret}
b
p '.dem{ret}

b 15,27,8,53
l 1,'We can look at the records in this file,
l 2,'one record at a time.
l 3,'To turn the page to the next record:
l 5,'    1. Press the PgDn key.
w 1,'{pgdn}
b


b 15,27,8,53
l 1,'Each record contains the name, address, and
l 2,'phone number of a different contact.  In your
l 3,'own work, you probably keep a similar file.
k
b


b 15,27,8,53
l 1,'By itself, this file is handy because it keeps
l 2,'information in a compact, organized form that
l 3,'you can easily access or change.
l 4,'But this file can be even more useful when
l 5,'used by another NUTSHELL PLUS II file.
k
b

b 15,27,8,53
l 1,'Let's close this file, then open another
l 2,'file.
l 3,'To close this file:
l 5,'    1. Press the Cancel key:    Esc
w 1,'{esc}
l 6,'    2. Press the ──┘ key.
w 0,'{ret}
b
p '{ret}


p '{home}
b 11,31,9,49
l 1,'Now we'll open a file used to keep track
l 2,'of all the things a busy person might need
l 3,'to do.
l 4,'To open a file called DATES:
l 6,'    1. Type:    dates
w 1,'dates
l 7,'    2. Press the ──┘ key.
w 0,'{ret}
b
p '.dem{ret}


b 15,27,8,53
l 1,'In this file, you can see when activities
l 2,'have been planned, and what actions were
l 3,'taken on these dates.  Each record shows
l 4,'a different planned activity, its priority,
l 5,'what happened as a result.
k
b

b 15,27,5,53
l 1,'To turn the page to the next record:
l 3,'    1. Press the PgDn key.
w 1,'{pgdn}
b

b 15,27,8,53
l 1,'This file too, by itself, is useful for
l 2,'organizing a busy day.  But wouldn't it be
l 3,'even more useful in combination with the first
l 4,'file?
k
b

b 15,27,9,53
l 1,'This file has fields for the name of the
l 2,'person to contact for each activity.  It would
l 3,'be useful to also have the contact's phone
l 4,'number.  With Nutshell, we can link the two
l 5,'files, so the information can be used together.
k
b

b 15,27,9,53
l 1,'To link files, there needs to be data that the
l 2,'two files have in common.  In this case, each
l 3,'file has a field for Last Name.  We can link
l 4,'the files so that each record in this file has
l 5,'a corresponding record with the SAME NAME in
l 6,'the other file.
k
b

b 15,27,7,53
l 1,'Now let's link the files, by first displaying
l 2,'the Define screen.
l 3,'To select the Define option:
l 5,'    1. Hold down the Alt key and type:  d
w 1,'{a-d}
b

b 15,27,5,53
l 1,'To select the Link Files option:
l 3,'    1. Hold down the Alt key and type:  L
w 1,'{a-l}
b

b 15,27,8,53
l 1,'Now we'll create a link to the LOOKUP FILE,
l 2,'the file with the names and addresses.  To
l 3,'create a link, we need to specify the name of
l 4,'the lookup file, then indicate the names of
l 5,'the two fields that have the same kind of data.
k
b

b 15,27,6,53
l 1,'To specify the name of the LOOKUP FILE:
l 3,'    1. Type:  names
w 1,'names
l 4,'    2. Press the ──┘ key.
w 0,'{ret}
b
p '.dem{ret}

b 6,27,8,53
l 1,'Nutshell opens the Names file and displays a
l 2,'list of the fields defined in that file.  Now
l 3,'we select the field in the lookup file that
l 4,'corresponds to a similar field in the current
l 5,'file.  This field is called the MATCH FIELD.
k
b


b 6,27,8,53
l 1,'We'll choose the Last Name in the Names file
l 2,'as the Match Field, because there is a field
l 3,'in the current file that has similar data.
l 4,'To select the Last Name field:
l 6,'    1. Press the ──┘ key.
w 0,'{ret}
b
p '{ret}

b 7,27,8,53
l 1,'Now Nutshell displays a list of the fields in
l 2,'the current file.  We next need to specify the
l 3,'field in the current file that corresponds
l 4,'to the match field.  This field in the current
l 5,'file is called the TRIGGER FIELD.
k
b

b 7,27,8,53
l 1,'We'll select Last Name in the current file as
l 2,'the Trigger Field.  When you later type data
l 3,'in this field, this "triggers" the matching
l 4,'process, in which Nutshell finds the record in
l 5,'the lookup file that matches what you type.
k
b


b 7,27,6,53
l 1,'To select Last Name as the Trigger Field:
l 3,'    1. Press the  (down arrow) key.
w 1,'{down}
l 4,'    2. Press the ──┘ key.
w 0,'{ret}
b
p '{ret}

b 15,27,8,53
l 1,'Good.  You have created a link to the lookup
l 2,'file.  For each last name in the current file,
l 3,'Nutshell will find the record in the lookup
l 4,'file with a matching last name.  Together, the
l 5,'two Last Name fields are called a FIELD PAIR.
k
b

b 15,27,7,53
l 1,'Let's stop creating links and return to the
l 2,'Browse screen.
l 3,'To stop creating Links:
l 5,'    1. Press the CANCEL key:  Esc
w 1,'{esc}

b 15,27,5,53
l 1,'To return to the Define screen:
l 3,'    1. Press the CANCEL key:  Esc
w 1,'{esc}

b 15,27,5,53
l 1,'To return to the Browse screen:
l 3,'    1. Press the CANCEL key:  Esc
w 1,'{esc}

b 15,27,7,53
l 1,'Once we've created a link to a lookup file,
l 2,'what can we do with it?  Nutshell provides
l 3,'many ways of taking advantage of the link
l 4,'connecting the two files.
k
b

b 15,27,8,53
l 1,'Take a look at the data in this record.
l 2,'Suppose we want to know the phone number for
l 3,'Patrick Rooney.  If we select the Zoom option,
l 4,'Nutshell will open the Names file and find
l 5,'the records with the same last name.
k
b

b 15,27,5,53
l 1,'To select the Zoom option:
l 3,'    1. Hold down the Alt key and type:  z
w 1,'{a-z}

b 15,27,8,53
l 1,'Nutshell opens the lookup file and finds the
l 2,'record with a matching last name.  The top
l 3,'line of the screen lists the two open files,
l 4,'and indicates that one record was found that
l 5,'matches the record we zoomed from.
k
b

b 15,27,8,53
l 1,'After Zooming to the lookup file, you can use
l 2,'it any way you want, just as if you had opened
l 3,'it from the Nutshell screen.  All the menu
l 4,'options are available.
k
b

b 15,27,7,53
l 1,'When we are done using the lookup file, we can
l 2,'return to the base file.
l 3,'To return to the base file:
l 5,'    1. Press the Cancel key:  Esc.
w 1,'{esc}
b

b 15,27,8,53
l 1,'Nutshell returns to the Dates file, the base
l 2,'of our activities.  The Browse screen is as we
l 3,'left it, displaying the same record.  The top
l 4,'line indicates the current file.
k
b

b 15,27,8,53
l 1,'While it is convenient to quickly zoom to a
l 2,'lookup file to see related information, you
l 3,'might also want to see the information from
l 4,'the lookup file together with data from the
l 5,'current file.
k
b

b 15,27,8,53
l 1,'Nutshell lets you include information from a
l 2,'lookup file directly on the layout.
l 3,'To select the layout option:
l 5,'    1. Hold down the Alt key and type:  L
w 1,'{a-l}
b

b 15,27,8,53
l 1,'Fields and layout text are arranged on this
l 2,'layout in a useful arrangement.  We can
l 3,'add to this arrangement, including on the
l 4,'layout as many fields from the lookup file
l 5,'as we need.
k
b

b 15,27,8,53
l 1,'Let's include the contact's phone number on
l 2,'the layout.  To include fields from a lookup
l 3,'file, we use the same menu option as for
l 4,'including fields on the layout from the
l 5,'current file: the Include option.
k
b

b 15,27,8,53
l 1,'First let's move the cursor to an area on the
l 2,'screen where we want the phone number to
l 3,'appear.
l 4,'To move the cursor to an empty area:
l 6,'    1. Press the  (down arrow) key 5 times.
w 1,'{down}{down}{down}{down}{down}
b

b 15,27,8,53
l 1,'Next we'll select the Include option to
l 2,'include a field on the layout.
l 3,'To select the Include option:
l 5,'    1. Hold down the Alt key and type:  i
w 0,'{a-i}
b
p '{a-i}

b 7,27,8,53
l 1,'Nutshell displays a list of the fields defined
l 2,'in the current file.  Rather than selecting
l 3,'one of these fields, we want to select a
l 4,'LOOKUP FIELD, a field from the lookup file.
k
b

b 7,27,8,53
l 1,'To select a lookup field to include on the
l 2,'layout, we need to select the Lookup option.
l 3,'To select the Lookup option:
l 5,'    1. Hold down the Alt key and type:  L
w 0,'{a-l}
b
p '{a-l}


b 7,27,8,53
l 1,'Nutshell lists the links to lookup files that
l 2,'have been defined.  Since in this case, there
l 3,'is only one link, the choice is easy.
l 4,'To select this link:
l 6,'    1. Press the ──┘ key.
w 0,'{ret}
b
p '{ret}


b 6,27,9,53
l 1,'Nutshell lists the Lookup Fields from the
l 2,'Names file.  We can choose fields from this
l 3,'list to include on the layout.
l 4,'To select the phone number field:
l 6,'    1. Press the  key 6 times.
w 1,'{down}{down}{down}{down}{down}{down}
l 7,'    2. Press the ──┘ key.
w 0,'{ret}
b
p '{ret}

b 15,27,8,53
l 1,'Nutshell includes the phone number field on
l 2,'the layout.  Nutshell uses a symbol that is
l 3,'slightly different than for the other fields
l 4,'to indicate the field comes from another file.
k
b

b 15,27,7,53
l 1,'Let's also include the City and State fields
l 2,'on the layout.
l 3,'To move the cursor to an empty area:
l 5,'    1. Press the  (down arrow) key.
w 1,'{down}
b

b 15,27,7,53
l 1,'To select the Include option:
l 3,'    1. Hold down the Alt key and type:  i
w 0,'{a-i}
b
p '{a-i}

b 6,27,9,53
l 1,'Nutshell shows the list of fields from the
l 2,'lookup file, just as we left it.  We can
l 3,'now select the City field to include.
l 4,'To include the City field:
l 6,'    1. Press the  (up arrow) key 3 times.
w 1,'{up}{up}{up}
l 7,'    2. Press the ──┘ key.
w 0,'{ret}
b
p '{ret}

b 15,27,8,53
l 1,'Nutshell includes the City field on the
l 2,'layout.  Now let's include the State field.
l 3,'To move the cursor to an empty area:
l 5,'    1. Press the  (down arrow) key.
w 1,'{down}
b

b 15,27,7,53
l 1,'To select the Include option:
l 3,'    1. Hold down the Alt key and type:  i
w 0,'{a-i}
b
p '{a-i}

b 6,27,7,53
l 1,'To include the State field:
l 3,'    1. Press the  (down arrow) key.
w 1,'{down}
l 4,'    2. Press the ──┘ key.
w 0,'{ret}
b
p '{ret}

b 15,27,7,53
l 1,'Let's return now to the Browse screen, to
l 2,'see the effect of including the lookup fields.
l 3,'To return to the Browse screen:
l 5,'    1. Press the CANCEL key:  Esc.
w 0,'{esc}
b
p '{esc}


b 15,27,9,53
l 1,'Using this layout, Nutshell displays data from
l 2,'the lookup fields along with the data that is
l 3,'stored in the current file.  Each record in
l 4,'this file has the appropriate phone number,
l 5,'city, and state displayed.
k
b

b 15,27,8,53
l 1,'When we add records, Nutshell will look up
l 2,'and display the phone number, city, and
l 3,'state for each new last name.
l 4,'To select the Add option:
l 6,'    1. Hold down the Alt key and type: a
w 0,'{a-a}
b
p '{a-a}

b 15,27,7,53
l 1,'To add data for the new activity:
l 3,'    1. Type:  Lunch Meeting
w 1,'Lunch Meeting
l 4,'    2. Press the ──│ (Tab) key to move the
l 5,'       cursor to the next field.
w 1,'{tab}
b


b 15,27,7,53
l 1,'To type the date for the new activity:
l 3,'    1. Type:  11/8/90
w 1,'11/8/90
l 4,'    2. Press the ──│ (Tab) key to move the
l 5,'       cursor to the next field.
w 1,'{tab}
b


b 15,27,7,53
l 1,'To type the priority for this activity:
l 3,'    1. Type:  A
w 1,'A
l 4,'    2. Press the ──│ (Tab) key to move the
l 5,'       cursor to the next field.
w 1,'{tab}
b

b 15,27,7,53
l 1,'To type the first name of the lunch contact:
l 3,'    1. Type:  Scott
w 1,'Scott
l 4,'    2. Press the ──│ (Tab) key to move the
l 5,'       cursor to the next field.
w 1,'{tab}
b


b 15,27,7,53
l 1,'To type the last name:
l 3,'    1. Type:  Dodenhoff
w 1,'Dodenhoff
l 4,'    2. Press the ──│ (Tab) key to move the
l 5,'       cursor to the next field.
w 1,'{tab}
b

b 15,27,8,53
l 1,'Note how the phone number, city, and state
l 2,'are displayed automatically.  Although this
l 3 'information is stored in the Names file, it
l 4,'is displayed in the Dates file.
k
b

b 15,27,8,53
l 1,'Because the looked-up information is stored
l 2,'in the lookup file, we don't actually type in
l 3,'these fields.  The cursor skips the lookup
l 4,'fields and moves to the Done Yet field.
k
b

b 15,27,7,53
l 1,'To indicate that this activity isn't done yet,
l 2,'we'll type "no" in the Done Yet field.
l 3,'To type "no" in the Done Yet field:
l 5,'    1. Type:  no
w 1,'no
b

b 15,27,8,53
l 1,'This lunch meeting has not yet happened, so
l 2,'we cannot fill in the data for the next two
l 3,'fields.  Let's add another record.
l 4,'To add a new record:
l 6,'    1. Press the EXECUTE key:  F10 or large +
w 1,'{f10}
b


b 15,27,7,53
l 1,'To add data for the next activity:
l 3,'    1. Type:  Confirm seminar enrollment
w 1,'Confirm seminar enrollment
l 4,'    2. Press the ──│ (Tab) key to move the
l 5,'       cursor to the next field.
w 1,'{tab}
b


b 15,27,7,53
l 1,'To type the date for the activity:
l 3,'    1. Type:  11/9/90
w 1,'11/9/90
l 4,'    2. Press the ──│ (Tab) key to move the
l 5,'       cursor to the next field.
w 1,'{tab}
b


b 15,27,7,53
l 1,'To type the priority for this activity:
l 3,'    1. Type:  B
w 1,'B
l 4,'    2. Press the ──│ (Tab) key to move the
l 5,'       cursor to the next field.
w 1,'{tab}
b

b 15,27,7,53
l 1,'To type the first name of the lunch contact:
l 3,'    1. Type:  Linda
w 1,'Linda
l 4,'    2. Press the ──│ (Tab) key to move the
l 5,'       cursor to the next field.
w 1,'{tab}
b

b 15,27,7,53
l 1,'To type the last name:
l 3,'    1. Type:  Smith
w 1,'Smith
l 4,'    2. Press the ──│ (Tab) key to move the
l 5,'       cursor to the next field.
w 1,'{tab}
b

b 15,27,7,53
l 1,'The data looked up for Smith is displayed
l 2,'automatically.  But this time Nutshell
l 3,'displays a message at the bottom of the
l 4,'screen.
k
b


b 15,27,8,53
l 1,'Apparently more than one person in the names
l 2,'file has the same last name.  Let's zoom to
l 3,'the Names file to find out more.
l 4,'To Zoom to the lookup file:
l 6,'    1. Hold down the Alt key and type:  z
w 1,'{a-z}
b

b 15,27,8,53
l 1,'NUTSHELL PLUS II again opens the Names file.
l 2,'This time the top line shows 2 records found.
l 3,'This record shows information about Bob Smith.
l 4,'To view the next record:
l 6,'    1. Press the PgDn key.
w 1,'{pgdn}
b

b 15,27,9,53
l 1,'Linda Smith, in Rochester, NY is the one
l 2,'we want.  Two records have the same last name
l 3,'but different addresses and phone numbers.
l 4,'Nutshell can help prevent this confusion.
l 5,'To return to the base file:
l 7,'    1. Press the CANCEL key:  Esc
w 1,'{esc}
b

b 15,27,8,53
l 1,'On the Add screen, NUTSHELL PLUS II still
l 2,'shows the incorrect phone number, city, and
l 3,'state, using the FIRST record with a last name
l 4,'of Smith.  To return to the Browse screen:
l 6,'    1. Press the Cancel key:  Esc.
w 1,'{esc}
b

b 15,27,8,53
l 1,'We can help prevent the confusion caused by
l 2,'duplicate last names by changing the way the
l 3,'files are linked.
l 4,'To select the Define option:
l 6,'    1. Hold down the Alt key and type:  d
w 1,'{a-d}
b

b 15,27,5,53
l 1,'To select the Link Files option:
l 3,'    1. Hold down the Alt key and type:  L
w 1,'{a-l}
b

b 15,27,8,53
l 1,'We can tell NUTSHELL PLUS II to be more strict
l 2,'by not only requiring the last names to match,
l 3,'but by requiring the first names to match as
l 4,'well. We'll tell NUTSHELL PLUS II to be more
l 5,'strict by adding a FIELD PAIR to this link.
k
b

b 15,27,8,53
l 1,'By adding a field pair, we'll tell NUTSHELL
l 2,'PLUS II to match records in the two files that
l 3,'have the same last names AND first names.
l 4,'To select the Add Field Pair option:
l 6,'    1. Hold down the Alt key and type:  a
w 1,'{a-a}

b 7,27,8,53
l 1,'NUTSHELL PLUS II lists the fields defined in
l 2,'the Lookup file.
l 3,'To select the First Name field from the list:
l 5,'    1. Press the  (down arrow) key.
w 1,'{down}
l 6,'    2. Press the ──┘ key.
w 0,'{ret}
b
p '{ret}

b 8,27,6,53
l 1,'Now Nutshell PLUS II lists the fields in the
l 2,'current file.  We'll select the field that
l 3,'matches the first name in the Names file.
k
b

b 8,27,6,53
l 1,'To select the First Name field from the list:
l 3,'    1. Press the  (up arrow) key.
w 1,'{up}
l 4,'    2. Press the ──┘ key.
w 1,'{ret}

b 15,27,8,53
l 1,'You have added a field pair to the link.
l 2,'The link now has two field pairs.  This
l 3,'link requires the last names to match AND
l 4,'the first names to match.
k
b

b 15,27,7,53
l 1,'Now let's return to the Browse screen, and see
l 2,'the effects of this change.
l 3,'To stop defining links:
l 5,'    1. Press the CANCEL key:  Esc.
w 1,'{esc}
b


b 15,27,5,53
l 1,'To return to the Browse screen:
l 3,'    1. Press the CANCEL key:  Esc.
w 1,'{esc}
b

b 15,27,8,53
l 1,'This record now displays the correct phone
l 2,'number, city, and state for Linda Smith.
l 3,'NUTSHELL PLUS II uses both the First Name AND
l 4,'Last Name to find the matching record. With the
l 5,'additional field pair, there is no confusion.
k
b

b 15,27,8,53
l 1,'You have seen that you can use links to:
d 175
l 2,'  Zoom to the lookup file, and
d 175
l 3,'  Include lookup fields on the layout.
d 175
l 4,'But that's not all you can do with links.
k
b

b 15,27,8,53
l 1,'You can also use links to:
l 2,'  Use lookup fields in calculation formulas
d 175
l 3,'  Sort records by values from lookup files.
d 175
l 4,'  Sub-summarize by values from lookup files.
d 175
l 5,'  Print records with values from lookup files.
k
b

b 15,27,8,53
l 1,'Creating and using links is important to
l 2,'making the most of Nutshell Plus II's power.
l 3,'For important information about links, refer
l 4,'to the manual, especially the sections called
l 5,'UNDERSTANDING THE CONCEPTS and DESIGNING FILES.
k
b


b 15,27,6,53
l 1,'To close this file:
l 3,'    1. Press the Cancel key:    Esc
w 1,'{esc}
l 4,'    2. Press the ──┘ key.
w 0,'{ret}
b
p '{ret}

b 10,31,9,49
l 2,'To exit NUTSHELL PLUS II:
l 4,'    1. Press the CANCEL key:   Esc.
w 0,'{esc}
b

p '{home}
v 0
a 6,14
b 2,1,24,80
l 2,'                     G U I D E D   T O U R   D E M O
l 4,'                Published by IRIS Software Products tm
l 5,'                        Stoughton, Mass. 02072
l 6,'                            [phone]
l 10,'                        "Using lookup files"
l 13,'                                               ┌────────────────────────┐
l 14,'                                               │ ┌──────────────────┐   │
l 15,'                                               │ │                  │ █ │
l 16,'                                               │ │                  │   │
l 17,'                                               │ │                  │   │
l 18,'                                               │ │                  │   │
l 19,'                                               │ │                  │ o │
l 20,'                                               │ │C>                │ o │
l 21,'                                               │ └──────────────────┘   │
l 22,'                                               └────────────────────────┘
l 14,'In this tour you have learned how to:

v 1
d 200
l 16,'* Create a LINK to a lookup file
d 175
l 16,'  Create a LINK to a lookup file
l 17,'* ZOOM to a lookup file
d 175
l 17,'  ZOOM to a lookup file
l 18,'* RETURN to the base file
d 175
l 18,'  RETURN to the base file
l 19,'* INCLUDE lookup fields on the layout
d 175
l 19,'  INCLUDE lookup fields on the layout
l 20,'* Add a FIELD PAIR to a link
d 175
l 20,'  Add a FIELD PAIR to a link
l 22,'     ─── press any key to exit ───
w
v 0
b
p '{home}{c-del}

  TOUR4.SCR
  VERSION 2.0 -- for Nutshell Plus II Version 2.0
  11/1/90
  Published by
  IRIS Software Products tm