Home » Archimedes archive » Archimedes World » AW-1994-04-Disc2.adf » Disk2Apr94 » !AWApr94/Goodies/PowerBase/PBaseDoc/BrowseEdit
!AWApr94/Goodies/PowerBase/PBaseDoc/BrowseEdit
This website contains an archive of files for the Acorn Electron, BBC Micro, Acorn Archimedes, Commodore 16 and Commodore 64 computers, which Dominic Ford has rescued from his private collection of floppy disks and cassettes.
Some of these files were originally commercial releases in the 1980s and 1990s, but they are now widely available online. I assume that copyright over them is no longer being asserted. If you own the copyright and would like files to be removed, please contact me.
Tape/disk: | Home » Archimedes archive » Archimedes World » AW-1994-04-Disc2.adf » Disk2Apr94 |
Filename: | !AWApr94/Goodies/PowerBase/PBaseDoc/BrowseEdit |
Read OK: | ✔ |
File size: | 573B bytes |
Load address: | 0000 |
Exec address: | 0000 |
File contents
Browsing, Searching and Editing =============================== This document describes all the features accessible from the Powerbase keypad together with other facilities associated with the editing of records. Databases which suppress the keypad and place controls on the record window may not include all the facilities described. Keystroke equivalents exist for many of the mouse operations and these are given in parentheses at the appropriate points. Subfiles ======== The concept of subfiles needs explaining before proceeding further. A Powerbase database comprises six subfiles which are numbered 0-5. When a database is opened the "active" subfile is always 0, as shown in the title bar of the record window, and new records will be added to subfile 0. You may ignore the other five if you wish. They occupy no additional room in the database: if the length has been defined as 100 records this means a common "pool" of 100 from which records may be all assigned to subfile 0 or distributed between the subfiles as the user wishes. Suggestions as to when several subfiles might be useful are given in the relevant sections below ("Changing subfiles - Using more than one subfile"). Appearance of record window =========================== A newly-opened database will display the first record in subfile 0. The title bar of the record window gives the record number and the primary key. The primary key field is highlighted by making its background pale yellow* instead of white like the rest and the field descriptor is red* indicating that the primary key is the currently-selected key. It is possible that two fields will be highlighted in this way meaning that the primary key is a composite one made up from the characters of two fields. (See 'Create' for a description of key-structure.) Most of the other descriptors will be black but dark blue* indicates a subsidiary key which has been created by indexing the field. (See 'Indexing'.) There may also be fields whose bounding boxes and text are dark green* indicating that a field is linked to a validation table. (See 'Validation'.) *These are the default colours. They may have been changed via the 'Colours' entry on the 'Miscellaneous' submenu. Moving about the database ========================= Six buttons on the top row of the keypad cause movement within the subfile. From left to right their actions when clicked on with SELECT are:- 1) First record (keystroke equivalent f3) 2) One record back (SH/f2) 3) 10 records back (SH/f7)* 4) 10 records forward (f7)* 5) One record forward (f2) 6) Last record (SH/f3) *The "fast forward/rewind" interval may be altered by typing in the writable icon between these two buttons. The file wraps around so that one forward from the last record takes you to the first and one back from the first record takes you to the last. In accordance with RISC OS conventions clicking with ADJUST instead of SELECT reverses these actions so that ADJUST over the first button, for instance, takes you to the last record rather than the first. This allows you to move about the database with fewer movements of the mouse. (Compare with the standard behaviour of scroll bars and scroll arrows.) The first button on the second row of the keypad ("Play") starts an automatic flip-through of the records and the last button on the row ("Stop") halts the process. If started with SELECT the records are displayed in forward order. ADJUST displays them in reverse order and you may swap the order at any time by a further click on "Play". The time for which each record remains on screen may be altered by changing the "fast forward" interval (see above). Changing keys ============= Two "key" buttons in the middle of the second row of the keypad enable you to cycle through the available keys in opposite directions (SH/f9 and f9 respectively). ADJUST reverses the action of SELECT. If no subsidiary keys have been defined these buttons have no effect. Otherwise you will see the red highlighting of the key-field descriptor move from one field to another as the key changes. The displayed record is always the first as defined by the ordering of the new key. Changing subfiles ================= A group of three buttons in the middle of the third row has the following effects when clicked with SELECT:- 1) Back one subfile (SH/f4) 2) Rotate subfiles (CT/f4) 3) Forward one subfile (f4) 1) and 3) change the current subfile to the previous one in sequence and the next in sequence. As with the corresponding buttons for moving from record to record "Forward" from subfile 5 takes you to subfile 0 and "Back" from 0 takes you to 5. ADJUST reverses these actions. "Rotate" renumbers the subfiles so that subfile 1 is the old subfile 0 etc. The old subfile 5 becomes the new subfile 0. Records which were previously in, say, subfile 2 will then be found in 3 instead. Since this is quite a drastic change you will be asked to confirm that it really is what you want before Powerbase proceeds. Using more than one subfile --------------------------- A Powerbase database consists, as stated earlier, of six subfiles numbered 0-5. You may use subfile 0 (which is used by default) and ignore the others if you wish, but there are occasions when users may find subfiles very useful. If, for example, you are maintaining a set of pupil records in a school you could assign one subfile to each year. At the end of a school year the promotion of Year 1 pupils to Year 2, Year 2 to Year 3 etc can be brought about by a single click on the "Rotate" button. A more common use of subfiles is to use 0 to hold the main set of records and 1 as a dumping ground for records which you want out of the way but don't want to get rid of permanently. Powerbase is actually used in this way in a Further Education college where the applications file for a course is built up in subfile 0. When students enrol on the course their records are updated to reflect this and records for those who have not appeared are moved into subfile 1. The enrolled students in 0 are then timetabled and class lists are printed. During the first week of the course there is a trickle of late enrolments which simply involve retrieving the required records from subfile 1 and reistating them in 0. The facilities for moving records, singly or in batches, from one subfile to another are described below. ("Deleting records") Searching for a record ====================== Searching by key ---------------- The icon bearing a record card and a quesion mark is the "Search" button. When clicked with SELECT (keystroke equivalent f1) the keypad expands to reveal a new section on the right. Type the key of the record to search for into the writable icon and either click on 'OK' or type RETURN. ('Current key' on the main menu gives access to a dialogue box describing how the key is constructed.) If the key exists in the current index the record will be found and displayed. If the key doesn't exist Powerbase bleeps and displays the nearest matching record with the key field flashing. If the database is a small one with keys which differ greatly from record to record then the displayed record may not look to be very near at all. The keypad will return to its normal appearance if you typed RETURN or used SELECT on the 'OK' button. If you want to use the "Search" function repeatedly it is more convenient to have the keypad remain in its expanded state and this can be achieved by clicking on 'OK' with ADJUST. If you do this you will notice that the icon to the left of the 'OK' button displays the number of matches found. The index being searched is displayed on the expanded keypad. Provided the database uses at least one subsidiary key you will see it change as you click on either of the "Change key" buttons. As described above the "Search" function searches only the current subfile. If you suspect that the record you require might be lurking in some other subfile you can force all six to be searched. This can be achieved by using ADJUST (keystroke equivalent SH/f1) instead of SELECT on the "Search" button or, after the keypad has expanded, by changing the selected radio button from the first to the second. If the record is found in some other subfile then that subfile will be made the current one and the record displayed. If searching on a numeric key you will only find the record by entering a number of exactly the right value. If the key is alphabetic, however, you may use just the first few letters if they are sufficient to distinguish the key from others. Searching by record number -------------------------- You may type a record number, preceded by #, (e.g. #1054) instead of a key. Provided the record is in use Powerbase will find and display it, regardless of what subfile it is in. If the record has been deleted or has never been assigned a "Record not in use" error is generated. Searching by filter ------------------- In the middle of the last row on the keypad is the "Filter" button. When clicked the keypad expands downwards revealing a writable icon into which you can type a Search Formula followed by clicking on 'OK' or typing RETURN. (See 'Printing' for an explanation of search formulae.) The keypad buttons used for browsing will now only display records which match the search formula, all non-matching records being "filtered out". The match is case specific by default but may be made non-specific by de-selecting the option switch on the keypad extension. Deselecting the "Filter" switch restores the keypad to its normal appearance and operation. Editing the database ==================== Adding new records ------------------ The icon bearing a record card and a plus sign is the "Add record" button (keystroke equivalent f10). Clicking with SELECT displays a blank record for you to fill in and the window title says "New record". The only field which you MUST fill in is the primary key field. Any or all of the rest of the fields (including subsidiary key fields) may be left blank. You may find on some fields that the keys you press will have no effect. This will happen, for example, if you try to type letters into a field which has been defined as numeric. If you type into a field which is highlighted in dark green you may get an error message. Such fields will only accept certain "values" which are listed in a Validation Table (see 'Validation'). To see what these allowed values are make sure the caret is in the relevant field then click on the "List values" button on the keypad (keystroke equivalent f8). If the table validation feature proves to be a nuisance you can turn it on and off with the 'Validate input' entry on the 'Validation' submenu. If the entry is ticked then validation is "on" (keystroke equivalent SH/f8). When you have entered as much of a record as you want to you can click "Add record" again for another blank record. The record which you have just entered is automatically written to the file. The same is true if you click any of the other keypad buttons or close the database altogether - you never need to do anything to "tell" Powerbase to update the file. There is indeed a button called "Force update" but you don't really need to use it. It is provided so that, during a long working session, you can force Powerbase to save to disc certain items (indices and validation tables) which are kept in memory while Powerbase is running. This is to guard against a power cut or system failure (such as some kind person switching your computer off for you when you've just popped out for a minute!). Using a template ---------------- Sometimes you want certain fields to be filled in with a fixed value on every new record. To save you typing the same thing into the same field every time, Powerbase provides an "Edit template" function which is accessible from the 'Miscellaneous' submenu. When you choose this you are presented with a blank record and the window title says "Enter data which you wish to appear by default on new records". Type in the required "fixed" data then click any of the usual keypad buttons. You will now find that the "blank" record displayed ever time you click "Add record" (f10) isn't really blank at all but already contains the data entered in your template. Note that this feature affects NEW records only. It doesn't have a retrospective effect on existing records. Using the clipboard ------------------- The buttons at the far left and right of the middle row of the keypad may be thought of as "Icon to clipboard" and "Clipboard to icon" respectively. They can save considerable time when you want to copy data from one field into another, whether in the same record or in a different one. When you click SELECT on "Icon to clipboard" the contents of the field which has the caret are stored in memory. Positioning the caret in another field and clicking on "Clipboard to icon" will copy the stored data into the new field. If the data is too long for the field it will be truncated to fit. Once you have data on the clipboard you may copy it into other fields as many times as you wish - the clipboard contents only change when you click on "Icon to clipboard" again. Choosing where the caret starts -------------------------------- When an existing or blank record is displayed Powerbase places the caret in the first editable field of the record. (This, incidentally, means the lowest-numbered field which may not necessarily LOOK like the first if the fields have been placed in strange positions in the window.) If you are going through the database making changes to one or two fields somewhere in the middle of the record it may be convenient to have the caret start somewhere else. Click MENU over the field where you wish the caret to start, go to the 'Field' sub-menu and choose 'Start editing'. Whenever a record is displayed the caret will now be placed in the chosen field. The same procedure is used to restore the normal starting position. Altering existing records ------------------------- A displayed record may be altered manually without any restrictions other than those applying to the addition of new records (see above). You will be asked to confirm an alteration which would result in a change to the primary key. The normal RISC OS conventions for editing writable icons apply, e.g. CTRL-U to clear the icon. As with new record entry you need do nothing to make Powerbase record your changes to disc - the process takes place when a different record is displayed, when a database is closed or when you quit Powerbase. Can I "undo" if I make a mistake? --------------------------------- Yes, provided that you haven't clicked on 'Force update' (a thing you should not normally need to do anyway) or done anything which causes Powerbase to display a different record. In other words you can undo changes made to the current record as long as it remains on the screen. Bring up the main menu and choose 'Restore record'. The displayed record will be returned to the state it was in when you displayed it and before you began to edit it. To restore single fields, click MENU over the required field, go to the 'Field' sub-menu and choose 'Restore field'. Note that only ordinary writable fields and check boxes may be restored; you can't restore external fields (see below) which is why a warning is normally issued before deleting such fields. Making the same change to many records -------------------------------------- To alter a given field in a set of records you must first point the mouse at the field and click MENU. This gives access to the 'Field' submenu on which the second item is 'Global changes'. In the first writable icon enter whatever you want the field changing to. In the second enter a Search Formula specifying which records are to be changed. (See 'Printing' and also "Searching by filter", above.) When you click on 'OK' or type RETURN all matching records in the current subfile will be altered in the way you have specified, provided that the new data will fit. If no search formula is entered then ALL records in the subfile will be changed. If no new data is typed into the first writable icon then the field in the matching records will be BLANKED. You may also use 'Global changes' to perform a simple calculation e.g. "+12" will cause 12 to be added to the current value in the field on all the matching records. "*5-13" will cause current the value to be multiplied by 5 and then decreased by 13. It is operations like these which are most likely to produce values which won't fit in the field, especially if floating-point numbers are involved. The operation isn't limited to Numeric fields, or even to other types of field consisting wholly of numerals: 'Powerbase' will find the number embedded in an entry such as "ABC45XYZ" and the operation "+12" would convert it to "ABX57XYZ". Deleting records ---------------- Only three keypad buttons still need explaining; the large one bearing the dustbin icon and the ones on either side of it: 1) Shift record back (SH/f6) Moves record into previous subfile. 2) Delete record (CT/f6) Removes record permamently. 3) Shift record forward (f6) Moves record to next subfile. The action of 2) is obviously more drastic than those of the others and you will be asked to confirm your choice before the record is actually deleted. The others "delete" records from the current subfile but do so without any fuss or bother because you can always get them back again. It is sometimes useful, especially when reinstating a record, to be able to "follow" it into its new subfile. You can do so by holding down ALT while you click on the keypad button. Deleting many records at once ----------------------------- Powerbase provides a 'Batch delete' choice on the 'Miscellaneous' submenu. It leads to a dialogue box which displays the same three icons as those on the three keypad buttons just described. Here, however, they are merely for identification. The radio buttons beneath them determine what will happen to the records and the default setting is for "Shift forward". Type a Search Formula (see 'Printing' and also "Searching by filter", above) and click 'OK' or type RETURN. All matching records in the current subfile will be moved or deleted as specified. External fields =============== External fields are described in some detail in connection with creating a new database (see 'Create'). They involve Text, Sprite or Draw files (one file for each record) which are stored within the database application directory and are either linked to buttons on the record screen or are actually displayed in large icons on the record screen. (The latter type cannot be used for Draw files.) They provide a means of associating record fields with pictures and with blocks of text which are too big to fit a normal text field. You can't edit an External field directly, even when it contains text as opposed to graphics. When you move the pointer over such a field it changes to two linked squares indicating that the data associated with the field is linked to it but not actually "in" it in the sense that data in ordinary editable fields is. To link a file with such a field all you need do is drag the file's icon onto the record window and drop it on the appropriate field. If, for example, the record includes a field represented by a "Text" button, i.e. one bearing a small version of the Edit icon, you may drop a Text file onto it. The button's icon changes to the small version of the Text file icon to indicate that the file has been linked. As long as the filer has "seen" the Edit application (or some other RISC OS text editor) clicking on the button with SELECT will load the file into the editor and display it. You may then edit the file and re-save it without altering its name and it will still be associated with the same field of the same record. Sprite and Draw files may be dropped onto the appropriate type of button in exactly the same way and may be displayed and edited with Paint and Draw respectively. A field of 'Text Block' type may also have a Text file dropped onto it. This time the text (or as much of it as will fit inside the icon's bounding box) is actually displayed on the record window. You can't edit the text directly (clicking with SELECT over it has no effect) but it is possible to export the file for editing (see below). Sprite files may be dropped onto and displayed in a field of 'Picture' type. Any new file dropped onto an external field which is already linked to a file simply replaces the old file with the new. NOTE If you drop a text file in the wrong place in the record window Powerbase will think you want to treat the file as like CSV file and import data from it (see 'CSV files') and the 'Import text file' window will appear. This is somewhat startling but harmless enough as long as you don't click on 'GO' or type RETURN! Click on 'Cancel' to get rid of the window. Editing external fields ----------------------- Clicking MENU over an external field makes available certain entries on the 'Field' submenu which are shaded for other types of field. 'Clear contents' enables you to delete the linked file from the database application. Since deleting a whole file is rather drastic you would probably like to be warned when this is about to happen. The message "Delete object? Are you sure?" normally appears, but you can disable it by clicking 'Warn of delete' on the 'Field' submenu so that the entry becomes unticked. Finally, 'Save contents' on the 'Field' submenu permits you to export the linked field to a filer window or directly into Edit, Paint or Draw. In the case of 'Text' and 'Text Block' fields a more convenient means of exporting the file is to select the field as if for printing then type SHIFT/f5. The 'Save' box containing the default filename will then appear. This works only when nothing else but the required field is selected. It can't be used with 'Picture', 'Sprite' or 'Draw' fields because these can never form part of a print selection and cannot therefore be selected with the mouse.
00000000 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | | 00000010 20 20 20 20 20 20 20 20 42 72 6f 77 73 69 6e 67 | Browsing| 00000020 2c 20 53 65 61 72 63 68 69 6e 67 20 61 6e 64 20 |, Searching and | 00000030 45 64 69 74 69 6e 67 0a 20 20 20 20 20 20 20 20 |Editing. | 00000040 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | | 00000050 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |================| 00000060 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a |===============.| 00000070 0a 54 68 69 73 20 64 6f 63 75 6d 65 6e 74 20 64 |.This document d| 00000080 65 73 63 72 69 62 65 73 20 61 6c 6c 20 74 68 65 |escribes all the| 00000090 20 66 65 61 74 75 72 65 73 20 61 63 63 65 73 73 | features access| 000000a0 69 62 6c 65 20 66 72 6f 6d 20 74 68 65 20 50 6f |ible from the Po| 000000b0 77 65 72 62 61 73 65 0a 6b 65 79 70 61 64 20 74 |werbase.keypad t| 000000c0 6f 67 65 74 68 65 72 20 77 69 74 68 20 6f 74 68 |ogether with oth| 000000d0 65 72 20 66 61 63 69 6c 69 74 69 65 73 20 61 73 |er facilities as| 000000e0 73 6f 63 69 61 74 65 64 20 77 69 74 68 20 74 68 |sociated with th| 000000f0 65 20 65 64 69 74 69 6e 67 20 6f 66 0a 72 65 63 |e editing of.rec| 00000100 6f 72 64 73 2e 20 44 61 74 61 62 61 73 65 73 20 |ords. Databases | 00000110 77 68 69 63 68 20 73 75 70 70 72 65 73 73 20 74 |which suppress t| 00000120 68 65 20 6b 65 79 70 61 64 20 61 6e 64 20 70 6c |he keypad and pl| 00000130 61 63 65 20 63 6f 6e 74 72 6f 6c 73 20 6f 6e 20 |ace controls on | 00000140 74 68 65 0a 72 65 63 6f 72 64 20 77 69 6e 64 6f |the.record windo| 00000150 77 20 6d 61 79 20 6e 6f 74 20 69 6e 63 6c 75 64 |w may not includ| 00000160 65 20 61 6c 6c 20 74 68 65 20 66 61 63 69 6c 69 |e all the facili| 00000170 74 69 65 73 20 64 65 73 63 72 69 62 65 64 2e 20 |ties described. | 00000180 4b 65 79 73 74 72 6f 6b 65 0a 65 71 75 69 76 61 |Keystroke.equiva| 00000190 6c 65 6e 74 73 20 65 78 69 73 74 20 66 6f 72 20 |lents exist for | 000001a0 6d 61 6e 79 20 6f 66 20 74 68 65 20 6d 6f 75 73 |many of the mous| 000001b0 65 20 6f 70 65 72 61 74 69 6f 6e 73 20 61 6e 64 |e operations and| 000001c0 20 74 68 65 73 65 20 61 72 65 20 67 69 76 65 6e | these are given| 000001d0 20 69 6e 0a 70 61 72 65 6e 74 68 65 73 65 73 20 | in.parentheses | 000001e0 61 74 20 74 68 65 20 61 70 70 72 6f 70 72 69 61 |at the appropria| 000001f0 74 65 20 70 6f 69 6e 74 73 2e 0a 0a 53 75 62 66 |te points...Subf| 00000200 69 6c 65 73 0a 3d 3d 3d 3d 3d 3d 3d 3d 0a 54 68 |iles.========.Th| 00000210 65 20 63 6f 6e 63 65 70 74 20 6f 66 20 73 75 62 |e concept of sub| 00000220 66 69 6c 65 73 20 6e 65 65 64 73 20 65 78 70 6c |files needs expl| 00000230 61 69 6e 69 6e 67 20 62 65 66 6f 72 65 20 70 72 |aining before pr| 00000240 6f 63 65 65 64 69 6e 67 20 66 75 72 74 68 65 72 |oceeding further| 00000250 2e 20 41 0a 50 6f 77 65 72 62 61 73 65 20 64 61 |. A.Powerbase da| 00000260 74 61 62 61 73 65 20 63 6f 6d 70 72 69 73 65 73 |tabase comprises| 00000270 20 73 69 78 20 73 75 62 66 69 6c 65 73 20 77 68 | six subfiles wh| 00000280 69 63 68 20 61 72 65 20 6e 75 6d 62 65 72 65 64 |ich are numbered| 00000290 20 30 2d 35 2e 20 57 68 65 6e 20 61 0a 64 61 74 | 0-5. When a.dat| 000002a0 61 62 61 73 65 20 69 73 20 6f 70 65 6e 65 64 20 |abase is opened | 000002b0 74 68 65 20 22 61 63 74 69 76 65 22 20 73 75 62 |the "active" sub| 000002c0 66 69 6c 65 20 69 73 20 61 6c 77 61 79 73 20 30 |file is always 0| 000002d0 2c 20 61 73 20 73 68 6f 77 6e 20 69 6e 20 74 68 |, as shown in th| 000002e0 65 20 74 69 74 6c 65 0a 62 61 72 20 6f 66 20 74 |e title.bar of t| 000002f0 68 65 20 72 65 63 6f 72 64 20 77 69 6e 64 6f 77 |he record window| 00000300 2c 20 61 6e 64 20 6e 65 77 20 72 65 63 6f 72 64 |, and new record| 00000310 73 20 77 69 6c 6c 20 62 65 20 61 64 64 65 64 20 |s will be added | 00000320 74 6f 20 73 75 62 66 69 6c 65 20 30 2e 20 59 6f |to subfile 0. Yo| 00000330 75 0a 6d 61 79 20 69 67 6e 6f 72 65 20 74 68 65 |u.may ignore the| 00000340 20 6f 74 68 65 72 20 66 69 76 65 20 69 66 20 79 | other five if y| 00000350 6f 75 20 77 69 73 68 2e 20 54 68 65 79 20 6f 63 |ou wish. They oc| 00000360 63 75 70 79 20 6e 6f 20 61 64 64 69 74 69 6f 6e |cupy no addition| 00000370 61 6c 20 72 6f 6f 6d 20 69 6e 20 74 68 65 0a 64 |al room in the.d| 00000380 61 74 61 62 61 73 65 3a 20 69 66 20 74 68 65 20 |atabase: if the | 00000390 6c 65 6e 67 74 68 20 68 61 73 20 62 65 65 6e 20 |length has been | 000003a0 64 65 66 69 6e 65 64 20 61 73 20 31 30 30 20 72 |defined as 100 r| 000003b0 65 63 6f 72 64 73 20 74 68 69 73 20 6d 65 61 6e |ecords this mean| 000003c0 73 20 61 20 63 6f 6d 6d 6f 6e 0a 22 70 6f 6f 6c |s a common."pool| 000003d0 22 20 6f 66 20 31 30 30 20 66 72 6f 6d 20 77 68 |" of 100 from wh| 000003e0 69 63 68 20 72 65 63 6f 72 64 73 20 6d 61 79 20 |ich records may | 000003f0 62 65 20 61 6c 6c 20 61 73 73 69 67 6e 65 64 20 |be all assigned | 00000400 74 6f 20 73 75 62 66 69 6c 65 20 30 20 6f 72 0a |to subfile 0 or.| 00000410 64 69 73 74 72 69 62 75 74 65 64 20 62 65 74 77 |distributed betw| 00000420 65 65 6e 20 74 68 65 20 73 75 62 66 69 6c 65 73 |een the subfiles| 00000430 20 61 73 20 74 68 65 20 75 73 65 72 20 77 69 73 | as the user wis| 00000440 68 65 73 2e 20 53 75 67 67 65 73 74 69 6f 6e 73 |hes. Suggestions| 00000450 20 61 73 20 74 6f 20 77 68 65 6e 0a 73 65 76 65 | as to when.seve| 00000460 72 61 6c 20 73 75 62 66 69 6c 65 73 20 6d 69 67 |ral subfiles mig| 00000470 68 74 20 62 65 20 75 73 65 66 75 6c 20 61 72 65 |ht be useful are| 00000480 20 67 69 76 65 6e 20 69 6e 20 74 68 65 20 72 65 | given in the re| 00000490 6c 65 76 61 6e 74 20 73 65 63 74 69 6f 6e 73 20 |levant sections | 000004a0 62 65 6c 6f 77 0a 28 22 43 68 61 6e 67 69 6e 67 |below.("Changing| 000004b0 20 73 75 62 66 69 6c 65 73 20 2d 20 55 73 69 6e | subfiles - Usin| 000004c0 67 20 6d 6f 72 65 20 74 68 61 6e 20 6f 6e 65 20 |g more than one | 000004d0 73 75 62 66 69 6c 65 22 29 2e 0a 0a 41 70 70 65 |subfile")...Appe| 000004e0 61 72 61 6e 63 65 20 6f 66 20 72 65 63 6f 72 64 |arance of record| 000004f0 20 77 69 6e 64 6f 77 0a 3d 3d 3d 3d 3d 3d 3d 3d | window.========| 00000500 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |================| 00000510 3d 3d 3d 0a 41 20 6e 65 77 6c 79 2d 6f 70 65 6e |===.A newly-open| 00000520 65 64 20 64 61 74 61 62 61 73 65 20 77 69 6c 6c |ed database will| 00000530 20 64 69 73 70 6c 61 79 20 74 68 65 20 66 69 72 | display the fir| 00000540 73 74 20 72 65 63 6f 72 64 20 69 6e 20 73 75 62 |st record in sub| 00000550 66 69 6c 65 20 30 2e 20 54 68 65 0a 74 69 74 6c |file 0. The.titl| 00000560 65 20 62 61 72 20 6f 66 20 74 68 65 20 72 65 63 |e bar of the rec| 00000570 6f 72 64 20 77 69 6e 64 6f 77 20 67 69 76 65 73 |ord window gives| 00000580 20 74 68 65 20 72 65 63 6f 72 64 20 6e 75 6d 62 | the record numb| 00000590 65 72 20 61 6e 64 20 74 68 65 20 70 72 69 6d 61 |er and the prima| 000005a0 72 79 20 6b 65 79 2e 0a 54 68 65 20 70 72 69 6d |ry key..The prim| 000005b0 61 72 79 20 6b 65 79 20 66 69 65 6c 64 20 69 73 |ary key field is| 000005c0 20 68 69 67 68 6c 69 67 68 74 65 64 20 62 79 20 | highlighted by | 000005d0 6d 61 6b 69 6e 67 20 69 74 73 20 62 61 63 6b 67 |making its backg| 000005e0 72 6f 75 6e 64 20 70 61 6c 65 20 79 65 6c 6c 6f |round pale yello| 000005f0 77 2a 0a 69 6e 73 74 65 61 64 20 6f 66 20 77 68 |w*.instead of wh| 00000600 69 74 65 20 6c 69 6b 65 20 74 68 65 20 72 65 73 |ite like the res| 00000610 74 20 61 6e 64 20 74 68 65 20 66 69 65 6c 64 20 |t and the field | 00000620 64 65 73 63 72 69 70 74 6f 72 20 69 73 20 72 65 |descriptor is re| 00000630 64 2a 20 69 6e 64 69 63 61 74 69 6e 67 0a 74 68 |d* indicating.th| 00000640 61 74 20 74 68 65 20 70 72 69 6d 61 72 79 20 6b |at the primary k| 00000650 65 79 20 69 73 20 74 68 65 20 63 75 72 72 65 6e |ey is the curren| 00000660 74 6c 79 2d 73 65 6c 65 63 74 65 64 20 6b 65 79 |tly-selected key| 00000670 2e 20 49 74 20 69 73 20 70 6f 73 73 69 62 6c 65 |. It is possible| 00000680 20 74 68 61 74 20 74 77 6f 0a 66 69 65 6c 64 73 | that two.fields| 00000690 20 77 69 6c 6c 20 62 65 20 68 69 67 68 6c 69 67 | will be highlig| 000006a0 68 74 65 64 20 69 6e 20 74 68 69 73 20 77 61 79 |hted in this way| 000006b0 20 6d 65 61 6e 69 6e 67 20 74 68 61 74 20 74 68 | meaning that th| 000006c0 65 20 70 72 69 6d 61 72 79 20 6b 65 79 20 69 73 |e primary key is| 000006d0 20 61 0a 63 6f 6d 70 6f 73 69 74 65 20 6f 6e 65 | a.composite one| 000006e0 20 6d 61 64 65 20 75 70 20 66 72 6f 6d 20 74 68 | made up from th| 000006f0 65 20 63 68 61 72 61 63 74 65 72 73 20 6f 66 20 |e characters of | 00000700 74 77 6f 20 66 69 65 6c 64 73 2e 20 28 53 65 65 |two fields. (See| 00000710 20 27 43 72 65 61 74 65 27 20 66 6f 72 20 61 0a | 'Create' for a.| 00000720 64 65 73 63 72 69 70 74 69 6f 6e 20 6f 66 20 6b |description of k| 00000730 65 79 2d 73 74 72 75 63 74 75 72 65 2e 29 20 4d |ey-structure.) M| 00000740 6f 73 74 20 6f 66 20 74 68 65 20 6f 74 68 65 72 |ost of the other| 00000750 20 64 65 73 63 72 69 70 74 6f 72 73 20 77 69 6c | descriptors wil| 00000760 6c 20 62 65 20 62 6c 61 63 6b 0a 62 75 74 20 64 |l be black.but d| 00000770 61 72 6b 20 62 6c 75 65 2a 20 69 6e 64 69 63 61 |ark blue* indica| 00000780 74 65 73 20 61 20 73 75 62 73 69 64 69 61 72 79 |tes a subsidiary| 00000790 20 6b 65 79 20 77 68 69 63 68 20 68 61 73 20 62 | key which has b| 000007a0 65 65 6e 20 63 72 65 61 74 65 64 20 62 79 20 69 |een created by i| 000007b0 6e 64 65 78 69 6e 67 0a 74 68 65 20 66 69 65 6c |ndexing.the fiel| 000007c0 64 2e 20 28 53 65 65 20 27 49 6e 64 65 78 69 6e |d. (See 'Indexin| 000007d0 67 27 2e 29 20 54 68 65 72 65 20 6d 61 79 20 61 |g'.) There may a| 000007e0 6c 73 6f 20 62 65 20 66 69 65 6c 64 73 20 77 68 |lso be fields wh| 000007f0 6f 73 65 20 62 6f 75 6e 64 69 6e 67 20 62 6f 78 |ose bounding box| 00000800 65 73 0a 61 6e 64 20 74 65 78 74 20 61 72 65 20 |es.and text are | 00000810 64 61 72 6b 20 67 72 65 65 6e 2a 20 69 6e 64 69 |dark green* indi| 00000820 63 61 74 69 6e 67 20 74 68 61 74 20 61 20 66 69 |cating that a fi| 00000830 65 6c 64 20 69 73 20 6c 69 6e 6b 65 64 20 74 6f |eld is linked to| 00000840 20 61 20 76 61 6c 69 64 61 74 69 6f 6e 0a 74 61 | a validation.ta| 00000850 62 6c 65 2e 20 28 53 65 65 20 27 56 61 6c 69 64 |ble. (See 'Valid| 00000860 61 74 69 6f 6e 27 2e 29 0a 0a 20 20 20 20 20 20 |ation'.).. | 00000870 20 20 2a 54 68 65 73 65 20 61 72 65 20 74 68 65 | *These are the| 00000880 20 64 65 66 61 75 6c 74 20 63 6f 6c 6f 75 72 73 | default colours| 00000890 2e 20 54 68 65 79 20 6d 61 79 20 68 61 76 65 20 |. They may have | 000008a0 62 65 65 6e 20 63 68 61 6e 67 65 64 0a 20 20 20 |been changed. | 000008b0 20 20 20 20 20 20 76 69 61 20 74 68 65 20 27 43 | via the 'C| 000008c0 6f 6c 6f 75 72 73 27 20 65 6e 74 72 79 20 6f 6e |olours' entry on| 000008d0 20 74 68 65 20 27 4d 69 73 63 65 6c 6c 61 6e 65 | the 'Miscellane| 000008e0 6f 75 73 27 20 73 75 62 6d 65 6e 75 2e 0a 0a 4d |ous' submenu...M| 000008f0 6f 76 69 6e 67 20 61 62 6f 75 74 20 74 68 65 20 |oving about the | 00000900 64 61 74 61 62 61 73 65 20 0a 3d 3d 3d 3d 3d 3d |database .======| 00000910 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |================| 00000920 3d 3d 3d 0a 53 69 78 20 62 75 74 74 6f 6e 73 20 |===.Six buttons | 00000930 6f 6e 20 74 68 65 20 74 6f 70 20 72 6f 77 20 6f |on the top row o| 00000940 66 20 74 68 65 20 6b 65 79 70 61 64 20 63 61 75 |f the keypad cau| 00000950 73 65 20 6d 6f 76 65 6d 65 6e 74 20 77 69 74 68 |se movement with| 00000960 69 6e 20 74 68 65 20 73 75 62 66 69 6c 65 2e 0a |in the subfile..| 00000970 46 72 6f 6d 20 6c 65 66 74 20 74 6f 20 72 69 67 |From left to rig| 00000980 68 74 20 74 68 65 69 72 20 61 63 74 69 6f 6e 73 |ht their actions| 00000990 20 77 68 65 6e 20 63 6c 69 63 6b 65 64 20 6f 6e | when clicked on| 000009a0 20 77 69 74 68 20 53 45 4c 45 43 54 20 61 72 65 | with SELECT are| 000009b0 3a 2d 0a 0a 20 20 20 20 20 20 20 20 31 29 20 46 |:-.. 1) F| 000009c0 69 72 73 74 20 72 65 63 6f 72 64 20 28 6b 65 79 |irst record (key| 000009d0 73 74 72 6f 6b 65 20 65 71 75 69 76 61 6c 65 6e |stroke equivalen| 000009e0 74 20 66 33 29 0a 20 20 20 20 20 20 20 20 32 29 |t f3). 2)| 000009f0 20 4f 6e 65 20 72 65 63 6f 72 64 20 62 61 63 6b | One record back| 00000a00 20 28 53 48 2f 66 32 29 0a 20 20 20 20 20 20 20 | (SH/f2). | 00000a10 20 33 29 20 31 30 20 72 65 63 6f 72 64 73 20 62 | 3) 10 records b| 00000a20 61 63 6b 20 28 53 48 2f 66 37 29 2a 0a 20 20 20 |ack (SH/f7)*. | 00000a30 20 20 20 20 20 34 29 20 31 30 20 72 65 63 6f 72 | 4) 10 recor| 00000a40 64 73 20 66 6f 72 77 61 72 64 20 28 66 37 29 2a |ds forward (f7)*| 00000a50 0a 20 20 20 20 20 20 20 20 35 29 20 4f 6e 65 20 |. 5) One | 00000a60 72 65 63 6f 72 64 20 66 6f 72 77 61 72 64 20 28 |record forward (| 00000a70 66 32 29 0a 20 20 20 20 20 20 20 20 36 29 20 4c |f2). 6) L| 00000a80 61 73 74 20 72 65 63 6f 72 64 20 28 53 48 2f 66 |ast record (SH/f| 00000a90 33 29 0a 0a 20 20 20 20 20 20 20 20 2a 54 68 65 |3).. *The| 00000aa0 20 22 66 61 73 74 20 66 6f 72 77 61 72 64 2f 72 | "fast forward/r| 00000ab0 65 77 69 6e 64 22 20 69 6e 74 65 72 76 61 6c 20 |ewind" interval | 00000ac0 6d 61 79 20 62 65 20 61 6c 74 65 72 65 64 20 62 |may be altered b| 00000ad0 79 20 74 79 70 69 6e 67 0a 20 20 20 20 20 20 20 |y typing. | 00000ae0 20 20 69 6e 20 74 68 65 20 77 72 69 74 61 62 6c | in the writabl| 00000af0 65 20 69 63 6f 6e 20 62 65 74 77 65 65 6e 20 74 |e icon between t| 00000b00 68 65 73 65 20 74 77 6f 20 62 75 74 74 6f 6e 73 |hese two buttons| 00000b10 2e 0a 0a 54 68 65 20 66 69 6c 65 20 77 72 61 70 |...The file wrap| 00000b20 73 20 61 72 6f 75 6e 64 20 73 6f 20 74 68 61 74 |s around so that| 00000b30 20 6f 6e 65 20 66 6f 72 77 61 72 64 20 66 72 6f | one forward fro| 00000b40 6d 20 74 68 65 20 6c 61 73 74 20 72 65 63 6f 72 |m the last recor| 00000b50 64 20 74 61 6b 65 73 20 79 6f 75 20 74 6f 0a 74 |d takes you to.t| 00000b60 68 65 20 66 69 72 73 74 20 61 6e 64 20 6f 6e 65 |he first and one| 00000b70 20 62 61 63 6b 20 66 72 6f 6d 20 74 68 65 20 66 | back from the f| 00000b80 69 72 73 74 20 72 65 63 6f 72 64 20 74 61 6b 65 |irst record take| 00000b90 73 20 79 6f 75 20 74 6f 20 74 68 65 20 6c 61 73 |s you to the las| 00000ba0 74 2e 20 49 6e 0a 61 63 63 6f 72 64 61 6e 63 65 |t. In.accordance| 00000bb0 20 77 69 74 68 20 52 49 53 43 20 4f 53 20 63 6f | with RISC OS co| 00000bc0 6e 76 65 6e 74 69 6f 6e 73 20 63 6c 69 63 6b 69 |nventions clicki| 00000bd0 6e 67 20 77 69 74 68 20 41 44 4a 55 53 54 20 69 |ng with ADJUST i| 00000be0 6e 73 74 65 61 64 20 6f 66 20 53 45 4c 45 43 54 |nstead of SELECT| 00000bf0 0a 72 65 76 65 72 73 65 73 20 74 68 65 73 65 20 |.reverses these | 00000c00 61 63 74 69 6f 6e 73 20 73 6f 20 74 68 61 74 20 |actions so that | 00000c10 41 44 4a 55 53 54 20 6f 76 65 72 20 74 68 65 20 |ADJUST over the | 00000c20 66 69 72 73 74 20 62 75 74 74 6f 6e 2c 20 66 6f |first button, fo| 00000c30 72 20 69 6e 73 74 61 6e 63 65 2c 0a 74 61 6b 65 |r instance,.take| 00000c40 73 20 79 6f 75 20 74 6f 20 74 68 65 20 6c 61 73 |s you to the las| 00000c50 74 20 72 65 63 6f 72 64 20 72 61 74 68 65 72 20 |t record rather | 00000c60 74 68 61 6e 20 74 68 65 20 66 69 72 73 74 2e 20 |than the first. | 00000c70 54 68 69 73 20 61 6c 6c 6f 77 73 20 79 6f 75 20 |This allows you | 00000c80 74 6f 20 6d 6f 76 65 0a 61 62 6f 75 74 20 74 68 |to move.about th| 00000c90 65 20 64 61 74 61 62 61 73 65 20 77 69 74 68 20 |e database with | 00000ca0 66 65 77 65 72 20 6d 6f 76 65 6d 65 6e 74 73 20 |fewer movements | 00000cb0 6f 66 20 74 68 65 20 6d 6f 75 73 65 2e 20 28 43 |of the mouse. (C| 00000cc0 6f 6d 70 61 72 65 20 77 69 74 68 20 74 68 65 0a |ompare with the.| 00000cd0 73 74 61 6e 64 61 72 64 20 62 65 68 61 76 69 6f |standard behavio| 00000ce0 75 72 20 6f 66 20 73 63 72 6f 6c 6c 20 62 61 72 |ur of scroll bar| 00000cf0 73 20 61 6e 64 20 73 63 72 6f 6c 6c 20 61 72 72 |s and scroll arr| 00000d00 6f 77 73 2e 29 0a 0a 54 68 65 20 66 69 72 73 74 |ows.)..The first| 00000d10 20 62 75 74 74 6f 6e 20 6f 6e 20 74 68 65 20 73 | button on the s| 00000d20 65 63 6f 6e 64 20 72 6f 77 20 6f 66 20 74 68 65 |econd row of the| 00000d30 20 6b 65 79 70 61 64 20 28 22 50 6c 61 79 22 29 | keypad ("Play")| 00000d40 20 73 74 61 72 74 73 20 61 6e 0a 61 75 74 6f 6d | starts an.autom| 00000d50 61 74 69 63 20 66 6c 69 70 2d 74 68 72 6f 75 67 |atic flip-throug| 00000d60 68 20 6f 66 20 74 68 65 20 72 65 63 6f 72 64 73 |h of the records| 00000d70 20 61 6e 64 20 74 68 65 20 6c 61 73 74 20 62 75 | and the last bu| 00000d80 74 74 6f 6e 20 20 6f 6e 20 74 68 65 20 72 6f 77 |tton on the row| 00000d90 0a 28 22 53 74 6f 70 22 29 20 68 61 6c 74 73 20 |.("Stop") halts | 00000da0 74 68 65 20 70 72 6f 63 65 73 73 2e 20 49 66 20 |the process. If | 00000db0 73 74 61 72 74 65 64 20 77 69 74 68 20 53 45 4c |started with SEL| 00000dc0 45 43 54 20 74 68 65 20 72 65 63 6f 72 64 73 20 |ECT the records | 00000dd0 61 72 65 20 64 69 73 70 6c 61 79 65 64 0a 69 6e |are displayed.in| 00000de0 20 66 6f 72 77 61 72 64 20 6f 72 64 65 72 2e 20 | forward order. | 00000df0 41 44 4a 55 53 54 20 64 69 73 70 6c 61 79 73 20 |ADJUST displays | 00000e00 74 68 65 6d 20 69 6e 20 72 65 76 65 72 73 65 20 |them in reverse | 00000e10 6f 72 64 65 72 20 61 6e 64 20 79 6f 75 20 6d 61 |order and you ma| 00000e20 79 20 73 77 61 70 20 74 68 65 0a 6f 72 64 65 72 |y swap the.order| 00000e30 20 61 74 20 61 6e 79 20 74 69 6d 65 20 62 79 20 | at any time by | 00000e40 61 20 66 75 72 74 68 65 72 20 63 6c 69 63 6b 20 |a further click | 00000e50 6f 6e 20 22 50 6c 61 79 22 2e 20 54 68 65 20 74 |on "Play". The t| 00000e60 69 6d 65 20 66 6f 72 20 77 68 69 63 68 20 65 61 |ime for which ea| 00000e70 63 68 0a 72 65 63 6f 72 64 20 72 65 6d 61 69 6e |ch.record remain| 00000e80 73 20 6f 6e 20 73 63 72 65 65 6e 20 6d 61 79 20 |s on screen may | 00000e90 62 65 20 61 6c 74 65 72 65 64 20 62 79 20 63 68 |be altered by ch| 00000ea0 61 6e 67 69 6e 67 20 74 68 65 20 22 66 61 73 74 |anging the "fast| 00000eb0 20 66 6f 72 77 61 72 64 22 0a 69 6e 74 65 72 76 | forward".interv| 00000ec0 61 6c 20 28 73 65 65 20 61 62 6f 76 65 29 2e 0a |al (see above)..| 00000ed0 0a 43 68 61 6e 67 69 6e 67 20 6b 65 79 73 0a 3d |.Changing keys.=| 00000ee0 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a 54 77 6f |============.Two| 00000ef0 20 22 6b 65 79 22 20 62 75 74 74 6f 6e 73 20 69 | "key" buttons i| 00000f00 6e 20 74 68 65 20 6d 69 64 64 6c 65 20 6f 66 20 |n the middle of | 00000f10 74 68 65 20 73 65 63 6f 6e 64 20 72 6f 77 20 6f |the second row o| 00000f20 66 20 74 68 65 20 6b 65 79 70 61 64 20 65 6e 61 |f the keypad ena| 00000f30 62 6c 65 20 79 6f 75 0a 74 6f 20 63 79 63 6c 65 |ble you.to cycle| 00000f40 20 74 68 72 6f 75 67 68 20 74 68 65 20 61 76 61 | through the ava| 00000f50 69 6c 61 62 6c 65 20 6b 65 79 73 20 69 6e 20 6f |ilable keys in o| 00000f60 70 70 6f 73 69 74 65 20 64 69 72 65 63 74 69 6f |pposite directio| 00000f70 6e 73 20 28 53 48 2f 66 39 20 61 6e 64 20 66 39 |ns (SH/f9 and f9| 00000f80 0a 72 65 73 70 65 63 74 69 76 65 6c 79 29 2e 20 |.respectively). | 00000f90 41 44 4a 55 53 54 20 72 65 76 65 72 73 65 73 20 |ADJUST reverses | 00000fa0 74 68 65 20 61 63 74 69 6f 6e 20 6f 66 20 53 45 |the action of SE| 00000fb0 4c 45 43 54 2e 20 49 66 20 6e 6f 20 73 75 62 73 |LECT. If no subs| 00000fc0 69 64 69 61 72 79 20 6b 65 79 73 0a 68 61 76 65 |idiary keys.have| 00000fd0 20 62 65 65 6e 20 64 65 66 69 6e 65 64 20 74 68 | been defined th| 00000fe0 65 73 65 20 62 75 74 74 6f 6e 73 20 68 61 76 65 |ese buttons have| 00000ff0 20 6e 6f 20 65 66 66 65 63 74 2e 20 4f 74 68 65 | no effect. Othe| 00001000 72 77 69 73 65 20 79 6f 75 20 77 69 6c 6c 20 73 |rwise you will s| 00001010 65 65 20 74 68 65 0a 72 65 64 20 68 69 67 68 6c |ee the.red highl| 00001020 69 67 68 74 69 6e 67 20 6f 66 20 74 68 65 20 6b |ighting of the k| 00001030 65 79 2d 66 69 65 6c 64 20 64 65 73 63 72 69 70 |ey-field descrip| 00001040 74 6f 72 20 6d 6f 76 65 20 66 72 6f 6d 20 6f 6e |tor move from on| 00001050 65 20 66 69 65 6c 64 20 74 6f 20 61 6e 6f 74 68 |e field to anoth| 00001060 65 72 0a 61 73 20 74 68 65 20 6b 65 79 20 63 68 |er.as the key ch| 00001070 61 6e 67 65 73 2e 20 54 68 65 20 64 69 73 70 6c |anges. The displ| 00001080 61 79 65 64 20 72 65 63 6f 72 64 20 69 73 20 61 |ayed record is a| 00001090 6c 77 61 79 73 20 74 68 65 20 66 69 72 73 74 20 |lways the first | 000010a0 61 73 20 64 65 66 69 6e 65 64 20 62 79 0a 74 68 |as defined by.th| 000010b0 65 20 6f 72 64 65 72 69 6e 67 20 6f 66 20 74 68 |e ordering of th| 000010c0 65 20 6e 65 77 20 6b 65 79 2e 0a 0a 43 68 61 6e |e new key...Chan| 000010d0 67 69 6e 67 20 73 75 62 66 69 6c 65 73 0a 3d 3d |ging subfiles.==| 000010e0 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a |===============.| 000010f0 41 20 67 72 6f 75 70 20 6f 66 20 74 68 72 65 65 |A group of three| 00001100 20 62 75 74 74 6f 6e 73 20 69 6e 20 74 68 65 20 | buttons in the | 00001110 6d 69 64 64 6c 65 20 6f 66 20 74 68 65 20 74 68 |middle of the th| 00001120 69 72 64 20 72 6f 77 20 68 61 73 20 74 68 65 20 |ird row has the | 00001130 66 6f 6c 6c 6f 77 69 6e 67 0a 65 66 66 65 63 74 |following.effect| 00001140 73 20 77 68 65 6e 20 63 6c 69 63 6b 65 64 20 77 |s when clicked w| 00001150 69 74 68 20 53 45 4c 45 43 54 3a 2d 0a 0a 20 20 |ith SELECT:-.. | 00001160 20 20 20 20 20 20 31 29 20 42 61 63 6b 20 6f 6e | 1) Back on| 00001170 65 20 73 75 62 66 69 6c 65 20 28 53 48 2f 66 34 |e subfile (SH/f4| 00001180 29 20 20 20 20 20 0a 20 20 20 20 20 20 20 20 32 |) . 2| 00001190 29 20 52 6f 74 61 74 65 20 73 75 62 66 69 6c 65 |) Rotate subfile| 000011a0 73 20 28 43 54 2f 66 34 29 20 20 20 20 20 20 0a |s (CT/f4) .| 000011b0 20 20 20 20 20 20 20 20 33 29 20 46 6f 72 77 61 | 3) Forwa| 000011c0 72 64 20 6f 6e 65 20 73 75 62 66 69 6c 65 20 28 |rd one subfile (| 000011d0 66 34 29 20 20 20 20 0a 0a 31 29 20 61 6e 64 20 |f4) ..1) and | 000011e0 33 29 20 63 68 61 6e 67 65 20 74 68 65 20 63 75 |3) change the cu| 000011f0 72 72 65 6e 74 20 73 75 62 66 69 6c 65 20 74 6f |rrent subfile to| 00001200 20 74 68 65 20 70 72 65 76 69 6f 75 73 20 6f 6e | the previous on| 00001210 65 20 69 6e 20 73 65 71 75 65 6e 63 65 20 61 6e |e in sequence an| 00001220 64 20 74 68 65 0a 6e 65 78 74 20 69 6e 20 73 65 |d the.next in se| 00001230 71 75 65 6e 63 65 2e 20 41 73 20 77 69 74 68 20 |quence. As with | 00001240 74 68 65 20 63 6f 72 72 65 73 70 6f 6e 64 69 6e |the correspondin| 00001250 67 20 62 75 74 74 6f 6e 73 20 66 6f 72 20 6d 6f |g buttons for mo| 00001260 76 69 6e 67 20 66 72 6f 6d 20 72 65 63 6f 72 64 |ving from record| 00001270 0a 74 6f 20 72 65 63 6f 72 64 20 22 46 6f 72 77 |.to record "Forw| 00001280 61 72 64 22 20 66 72 6f 6d 20 73 75 62 66 69 6c |ard" from subfil| 00001290 65 20 35 20 74 61 6b 65 73 20 79 6f 75 20 74 6f |e 5 takes you to| 000012a0 20 73 75 62 66 69 6c 65 20 30 20 61 6e 64 20 22 | subfile 0 and "| 000012b0 42 61 63 6b 22 20 66 72 6f 6d 20 30 0a 74 61 6b |Back" from 0.tak| 000012c0 65 73 20 79 6f 75 20 74 6f 20 35 2e 20 41 44 4a |es you to 5. ADJ| 000012d0 55 53 54 20 72 65 76 65 72 73 65 73 20 74 68 65 |UST reverses the| 000012e0 73 65 20 61 63 74 69 6f 6e 73 2e 20 22 52 6f 74 |se actions. "Rot| 000012f0 61 74 65 22 20 72 65 6e 75 6d 62 65 72 73 20 74 |ate" renumbers t| 00001300 68 65 0a 73 75 62 66 69 6c 65 73 20 73 6f 20 74 |he.subfiles so t| 00001310 68 61 74 20 73 75 62 66 69 6c 65 20 31 20 69 73 |hat subfile 1 is| 00001320 20 74 68 65 20 6f 6c 64 20 73 75 62 66 69 6c 65 | the old subfile| 00001330 20 30 20 65 74 63 2e 20 20 54 68 65 20 6f 6c 64 | 0 etc. The old| 00001340 20 73 75 62 66 69 6c 65 20 35 0a 62 65 63 6f 6d | subfile 5.becom| 00001350 65 73 20 74 68 65 20 6e 65 77 20 73 75 62 66 69 |es the new subfi| 00001360 6c 65 20 30 2e 20 52 65 63 6f 72 64 73 20 77 68 |le 0. Records wh| 00001370 69 63 68 20 77 65 72 65 20 70 72 65 76 69 6f 75 |ich were previou| 00001380 73 6c 79 20 69 6e 2c 20 73 61 79 2c 20 73 75 62 |sly in, say, sub| 00001390 66 69 6c 65 20 32 0a 77 69 6c 6c 20 74 68 65 6e |file 2.will then| 000013a0 20 62 65 20 66 6f 75 6e 64 20 69 6e 20 33 20 69 | be found in 3 i| 000013b0 6e 73 74 65 61 64 2e 20 53 69 6e 63 65 20 74 68 |nstead. Since th| 000013c0 69 73 20 69 73 20 71 75 69 74 65 20 61 20 64 72 |is is quite a dr| 000013d0 61 73 74 69 63 20 63 68 61 6e 67 65 20 79 6f 75 |astic change you| 000013e0 0a 77 69 6c 6c 20 62 65 20 61 73 6b 65 64 20 74 |.will be asked t| 000013f0 6f 20 63 6f 6e 66 69 72 6d 20 74 68 61 74 20 69 |o confirm that i| 00001400 74 20 72 65 61 6c 6c 79 20 69 73 20 77 68 61 74 |t really is what| 00001410 20 79 6f 75 20 77 61 6e 74 20 62 65 66 6f 72 65 | you want before| 00001420 20 50 6f 77 65 72 62 61 73 65 0a 70 72 6f 63 65 | Powerbase.proce| 00001430 65 64 73 2e 0a 0a 55 73 69 6e 67 20 6d 6f 72 65 |eds...Using more| 00001440 20 74 68 61 6e 20 6f 6e 65 20 73 75 62 66 69 6c | than one subfil| 00001450 65 0a 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |e.--------------| 00001460 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a 41 20 |-------------.A | 00001470 50 6f 77 65 72 62 61 73 65 20 64 61 74 61 62 61 |Powerbase databa| 00001480 73 65 20 63 6f 6e 73 69 73 74 73 2c 20 61 73 20 |se consists, as | 00001490 73 74 61 74 65 64 20 65 61 72 6c 69 65 72 2c 20 |stated earlier, | 000014a0 6f 66 20 73 69 78 20 73 75 62 66 69 6c 65 73 20 |of six subfiles | 000014b0 6e 75 6d 62 65 72 65 64 0a 30 2d 35 2e 20 59 6f |numbered.0-5. Yo| 000014c0 75 20 6d 61 79 20 75 73 65 20 73 75 62 66 69 6c |u may use subfil| 000014d0 65 20 30 20 28 77 68 69 63 68 20 69 73 20 75 73 |e 0 (which is us| 000014e0 65 64 20 62 79 20 64 65 66 61 75 6c 74 29 20 61 |ed by default) a| 000014f0 6e 64 20 69 67 6e 6f 72 65 20 74 68 65 20 6f 74 |nd ignore the ot| 00001500 68 65 72 73 0a 69 66 20 79 6f 75 20 77 69 73 68 |hers.if you wish| 00001510 2c 20 62 75 74 20 74 68 65 72 65 20 61 72 65 20 |, but there are | 00001520 6f 63 63 61 73 69 6f 6e 73 20 77 68 65 6e 20 75 |occasions when u| 00001530 73 65 72 73 20 6d 61 79 20 66 69 6e 64 20 73 75 |sers may find su| 00001540 62 66 69 6c 65 73 20 76 65 72 79 0a 75 73 65 66 |bfiles very.usef| 00001550 75 6c 2e 20 49 66 2c 20 66 6f 72 20 65 78 61 6d |ul. If, for exam| 00001560 70 6c 65 2c 20 79 6f 75 20 61 72 65 20 6d 61 69 |ple, you are mai| 00001570 6e 74 61 69 6e 69 6e 67 20 61 20 73 65 74 20 6f |ntaining a set o| 00001580 66 20 70 75 70 69 6c 20 72 65 63 6f 72 64 73 20 |f pupil records | 00001590 69 6e 20 61 0a 73 63 68 6f 6f 6c 20 79 6f 75 20 |in a.school you | 000015a0 63 6f 75 6c 64 20 61 73 73 69 67 6e 20 6f 6e 65 |could assign one| 000015b0 20 73 75 62 66 69 6c 65 20 74 6f 20 65 61 63 68 | subfile to each| 000015c0 20 79 65 61 72 2e 20 41 74 20 74 68 65 20 65 6e | year. At the en| 000015d0 64 20 6f 66 20 61 20 73 63 68 6f 6f 6c 0a 79 65 |d of a school.ye| 000015e0 61 72 20 74 68 65 20 70 72 6f 6d 6f 74 69 6f 6e |ar the promotion| 000015f0 20 6f 66 20 59 65 61 72 20 31 20 70 75 70 69 6c | of Year 1 pupil| 00001600 73 20 74 6f 20 59 65 61 72 20 32 2c 20 59 65 61 |s to Year 2, Yea| 00001610 72 20 32 20 74 6f 20 59 65 61 72 20 33 20 65 74 |r 2 to Year 3 et| 00001620 63 20 63 61 6e 20 62 65 0a 62 72 6f 75 67 68 74 |c can be.brought| 00001630 20 61 62 6f 75 74 20 62 79 20 61 20 73 69 6e 67 | about by a sing| 00001640 6c 65 20 63 6c 69 63 6b 20 6f 6e 20 74 68 65 20 |le click on the | 00001650 22 52 6f 74 61 74 65 22 20 62 75 74 74 6f 6e 2e |"Rotate" button.| 00001660 20 0a 0a 41 20 6d 6f 72 65 20 63 6f 6d 6d 6f 6e | ..A more common| 00001670 20 75 73 65 20 6f 66 20 73 75 62 66 69 6c 65 73 | use of subfiles| 00001680 20 69 73 20 74 6f 20 75 73 65 20 30 20 74 6f 20 | is to use 0 to | 00001690 68 6f 6c 64 20 74 68 65 20 6d 61 69 6e 20 73 65 |hold the main se| 000016a0 74 20 6f 66 20 72 65 63 6f 72 64 73 0a 61 6e 64 |t of records.and| 000016b0 20 31 20 61 73 20 61 20 64 75 6d 70 69 6e 67 20 | 1 as a dumping | 000016c0 67 72 6f 75 6e 64 20 66 6f 72 20 72 65 63 6f 72 |ground for recor| 000016d0 64 73 20 77 68 69 63 68 20 79 6f 75 20 77 61 6e |ds which you wan| 000016e0 74 20 6f 75 74 20 6f 66 20 74 68 65 20 77 61 79 |t out of the way| 000016f0 20 62 75 74 0a 64 6f 6e 27 74 20 77 61 6e 74 20 | but.don't want | 00001700 74 6f 20 67 65 74 20 72 69 64 20 6f 66 20 70 65 |to get rid of pe| 00001710 72 6d 61 6e 65 6e 74 6c 79 2e 20 50 6f 77 65 72 |rmanently. Power| 00001720 62 61 73 65 20 69 73 20 61 63 74 75 61 6c 6c 79 |base is actually| 00001730 20 75 73 65 64 20 69 6e 20 74 68 69 73 0a 77 61 | used in this.wa| 00001740 79 20 69 6e 20 61 20 46 75 72 74 68 65 72 20 45 |y in a Further E| 00001750 64 75 63 61 74 69 6f 6e 20 63 6f 6c 6c 65 67 65 |ducation college| 00001760 20 77 68 65 72 65 20 74 68 65 20 61 70 70 6c 69 | where the appli| 00001770 63 61 74 69 6f 6e 73 20 66 69 6c 65 20 66 6f 72 |cations file for| 00001780 20 61 20 63 6f 75 72 73 65 0a 69 73 20 62 75 69 | a course.is bui| 00001790 6c 74 20 75 70 20 69 6e 20 73 75 62 66 69 6c 65 |lt up in subfile| 000017a0 20 30 2e 20 57 68 65 6e 20 73 74 75 64 65 6e 74 | 0. When student| 000017b0 73 20 65 6e 72 6f 6c 20 6f 6e 20 74 68 65 20 63 |s enrol on the c| 000017c0 6f 75 72 73 65 20 74 68 65 69 72 20 72 65 63 6f |ourse their reco| 000017d0 72 64 73 0a 61 72 65 20 75 70 64 61 74 65 64 20 |rds.are updated | 000017e0 74 6f 20 72 65 66 6c 65 63 74 20 74 68 69 73 20 |to reflect this | 000017f0 61 6e 64 20 72 65 63 6f 72 64 73 20 66 6f 72 20 |and records for | 00001800 74 68 6f 73 65 20 77 68 6f 20 68 61 76 65 20 6e |those who have n| 00001810 6f 74 20 61 70 70 65 61 72 65 64 20 61 72 65 0a |ot appeared are.| 00001820 6d 6f 76 65 64 20 69 6e 74 6f 20 73 75 62 66 69 |moved into subfi| 00001830 6c 65 20 31 2e 20 54 68 65 20 65 6e 72 6f 6c 6c |le 1. The enroll| 00001840 65 64 20 73 74 75 64 65 6e 74 73 20 69 6e 20 30 |ed students in 0| 00001850 20 61 72 65 20 74 68 65 6e 20 74 69 6d 65 74 61 | are then timeta| 00001860 62 6c 65 64 20 61 6e 64 0a 63 6c 61 73 73 20 6c |bled and.class l| 00001870 69 73 74 73 20 61 72 65 20 70 72 69 6e 74 65 64 |ists are printed| 00001880 2e 20 44 75 72 69 6e 67 20 74 68 65 20 66 69 72 |. During the fir| 00001890 73 74 20 77 65 65 6b 20 6f 66 20 74 68 65 20 63 |st week of the c| 000018a0 6f 75 72 73 65 20 74 68 65 72 65 20 69 73 20 61 |ourse there is a| 000018b0 0a 74 72 69 63 6b 6c 65 20 6f 66 20 6c 61 74 65 |.trickle of late| 000018c0 20 65 6e 72 6f 6c 6d 65 6e 74 73 20 77 68 69 63 | enrolments whic| 000018d0 68 20 73 69 6d 70 6c 79 20 69 6e 76 6f 6c 76 65 |h simply involve| 000018e0 20 72 65 74 72 69 65 76 69 6e 67 20 74 68 65 20 | retrieving the | 000018f0 72 65 71 75 69 72 65 64 0a 72 65 63 6f 72 64 73 |required.records| 00001900 20 66 72 6f 6d 20 73 75 62 66 69 6c 65 20 31 20 | from subfile 1 | 00001910 61 6e 64 20 72 65 69 73 74 61 74 69 6e 67 20 74 |and reistating t| 00001920 68 65 6d 20 69 6e 20 30 2e 0a 0a 54 68 65 20 66 |hem in 0...The f| 00001930 61 63 69 6c 69 74 69 65 73 20 66 6f 72 20 6d 6f |acilities for mo| 00001940 76 69 6e 67 20 72 65 63 6f 72 64 73 2c 20 73 69 |ving records, si| 00001950 6e 67 6c 79 20 6f 72 20 69 6e 20 62 61 74 63 68 |ngly or in batch| 00001960 65 73 2c 20 66 72 6f 6d 20 6f 6e 65 20 73 75 62 |es, from one sub| 00001970 66 69 6c 65 20 74 6f 0a 61 6e 6f 74 68 65 72 20 |file to.another | 00001980 61 72 65 20 64 65 73 63 72 69 62 65 64 20 62 65 |are described be| 00001990 6c 6f 77 2e 20 28 22 44 65 6c 65 74 69 6e 67 20 |low. ("Deleting | 000019a0 72 65 63 6f 72 64 73 22 29 0a 0a 53 65 61 72 63 |records")..Searc| 000019b0 68 69 6e 67 20 66 6f 72 20 61 20 72 65 63 6f 72 |hing for a recor| 000019c0 64 0a 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |d.==============| 000019d0 3d 3d 3d 3d 3d 3d 3d 3d 0a 0a 53 65 61 72 63 68 |========..Search| 000019e0 69 6e 67 20 62 79 20 6b 65 79 0a 2d 2d 2d 2d 2d |ing by key.-----| 000019f0 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a 54 68 65 20 |-----------.The | 00001a00 69 63 6f 6e 20 62 65 61 72 69 6e 67 20 61 20 72 |icon bearing a r| 00001a10 65 63 6f 72 64 20 63 61 72 64 20 61 6e 64 20 61 |ecord card and a| 00001a20 20 71 75 65 73 69 6f 6e 20 6d 61 72 6b 20 69 73 | quesion mark is| 00001a30 20 74 68 65 20 22 53 65 61 72 63 68 22 20 62 75 | the "Search" bu| 00001a40 74 74 6f 6e 2e 0a 57 68 65 6e 20 63 6c 69 63 6b |tton..When click| 00001a50 65 64 20 77 69 74 68 20 53 45 4c 45 43 54 20 28 |ed with SELECT (| 00001a60 6b 65 79 73 74 72 6f 6b 65 20 65 71 75 69 76 61 |keystroke equiva| 00001a70 6c 65 6e 74 20 66 31 29 20 74 68 65 20 6b 65 79 |lent f1) the key| 00001a80 70 61 64 20 65 78 70 61 6e 64 73 20 74 6f 0a 72 |pad expands to.r| 00001a90 65 76 65 61 6c 20 61 20 6e 65 77 20 73 65 63 74 |eveal a new sect| 00001aa0 69 6f 6e 20 6f 6e 20 74 68 65 20 72 69 67 68 74 |ion on the right| 00001ab0 2e 20 54 79 70 65 20 74 68 65 20 6b 65 79 20 6f |. Type the key o| 00001ac0 66 20 74 68 65 20 72 65 63 6f 72 64 20 74 6f 20 |f the record to | 00001ad0 73 65 61 72 63 68 20 66 6f 72 0a 69 6e 74 6f 20 |search for.into | 00001ae0 74 68 65 20 77 72 69 74 61 62 6c 65 20 69 63 6f |the writable ico| 00001af0 6e 20 61 6e 64 20 65 69 74 68 65 72 20 63 6c 69 |n and either cli| 00001b00 63 6b 20 6f 6e 20 27 4f 4b 27 20 6f 72 20 74 79 |ck on 'OK' or ty| 00001b10 70 65 20 52 45 54 55 52 4e 2e 20 28 27 43 75 72 |pe RETURN. ('Cur| 00001b20 72 65 6e 74 0a 6b 65 79 27 20 6f 6e 20 74 68 65 |rent.key' on the| 00001b30 20 6d 61 69 6e 20 6d 65 6e 75 20 67 69 76 65 73 | main menu gives| 00001b40 20 61 63 63 65 73 73 20 74 6f 20 61 20 64 69 61 | access to a dia| 00001b50 6c 6f 67 75 65 20 62 6f 78 20 64 65 73 63 72 69 |logue box descri| 00001b60 62 69 6e 67 20 68 6f 77 20 74 68 65 20 6b 65 79 |bing how the key| 00001b70 0a 69 73 20 63 6f 6e 73 74 72 75 63 74 65 64 2e |.is constructed.| 00001b80 29 20 49 66 20 74 68 65 20 6b 65 79 20 65 78 69 |) If the key exi| 00001b90 73 74 73 20 69 6e 20 74 68 65 20 63 75 72 72 65 |sts in the curre| 00001ba0 6e 74 20 69 6e 64 65 78 20 74 68 65 20 72 65 63 |nt index the rec| 00001bb0 6f 72 64 20 77 69 6c 6c 20 62 65 0a 66 6f 75 6e |ord will be.foun| 00001bc0 64 20 61 6e 64 20 64 69 73 70 6c 61 79 65 64 2e |d and displayed.| 00001bd0 20 49 66 20 74 68 65 20 6b 65 79 20 64 6f 65 73 | If the key does| 00001be0 6e 27 74 20 65 78 69 73 74 20 50 6f 77 65 72 62 |n't exist Powerb| 00001bf0 61 73 65 20 62 6c 65 65 70 73 20 61 6e 64 20 64 |ase bleeps and d| 00001c00 69 73 70 6c 61 79 73 0a 74 68 65 20 6e 65 61 72 |isplays.the near| 00001c10 65 73 74 20 6d 61 74 63 68 69 6e 67 20 72 65 63 |est matching rec| 00001c20 6f 72 64 20 77 69 74 68 20 74 68 65 20 6b 65 79 |ord with the key| 00001c30 20 66 69 65 6c 64 20 66 6c 61 73 68 69 6e 67 2e | field flashing.| 00001c40 20 49 66 20 74 68 65 20 64 61 74 61 62 61 73 65 | If the database| 00001c50 20 69 73 0a 61 20 73 6d 61 6c 6c 20 6f 6e 65 20 | is.a small one | 00001c60 77 69 74 68 20 6b 65 79 73 20 77 68 69 63 68 20 |with keys which | 00001c70 64 69 66 66 65 72 20 67 72 65 61 74 6c 79 20 66 |differ greatly f| 00001c80 72 6f 6d 20 72 65 63 6f 72 64 20 74 6f 20 72 65 |rom record to re| 00001c90 63 6f 72 64 20 74 68 65 6e 20 74 68 65 0a 64 69 |cord then the.di| 00001ca0 73 70 6c 61 79 65 64 20 72 65 63 6f 72 64 20 6d |splayed record m| 00001cb0 61 79 20 6e 6f 74 20 6c 6f 6f 6b 20 74 6f 20 62 |ay not look to b| 00001cc0 65 20 76 65 72 79 20 6e 65 61 72 20 61 74 20 61 |e very near at a| 00001cd0 6c 6c 2e 20 54 68 65 20 6b 65 79 70 61 64 20 77 |ll. The keypad w| 00001ce0 69 6c 6c 20 72 65 74 75 72 6e 0a 74 6f 20 69 74 |ill return.to it| 00001cf0 73 20 6e 6f 72 6d 61 6c 20 61 70 70 65 61 72 61 |s normal appeara| 00001d00 6e 63 65 20 69 66 20 79 6f 75 20 74 79 70 65 64 |nce if you typed| 00001d10 20 52 45 54 55 52 4e 20 6f 72 20 75 73 65 64 20 | RETURN or used | 00001d20 53 45 4c 45 43 54 20 6f 6e 20 74 68 65 20 27 4f |SELECT on the 'O| 00001d30 4b 27 0a 62 75 74 74 6f 6e 2e 20 49 66 20 79 6f |K'.button. If yo| 00001d40 75 20 77 61 6e 74 20 74 6f 20 75 73 65 20 74 68 |u want to use th| 00001d50 65 20 22 53 65 61 72 63 68 22 20 66 75 6e 63 74 |e "Search" funct| 00001d60 69 6f 6e 20 72 65 70 65 61 74 65 64 6c 79 20 69 |ion repeatedly i| 00001d70 74 20 69 73 20 6d 6f 72 65 0a 63 6f 6e 76 65 6e |t is more.conven| 00001d80 69 65 6e 74 20 74 6f 20 68 61 76 65 20 74 68 65 |ient to have the| 00001d90 20 6b 65 79 70 61 64 20 72 65 6d 61 69 6e 20 69 | keypad remain i| 00001da0 6e 20 69 74 73 20 65 78 70 61 6e 64 65 64 20 73 |n its expanded s| 00001db0 74 61 74 65 20 61 6e 64 20 74 68 69 73 20 63 61 |tate and this ca| 00001dc0 6e 20 62 65 0a 61 63 68 69 65 76 65 64 20 62 79 |n be.achieved by| 00001dd0 20 63 6c 69 63 6b 69 6e 67 20 6f 6e 20 27 4f 4b | clicking on 'OK| 00001de0 27 20 77 69 74 68 20 41 44 4a 55 53 54 2e 20 49 |' with ADJUST. I| 00001df0 66 20 79 6f 75 20 64 6f 20 74 68 69 73 20 79 6f |f you do this yo| 00001e00 75 20 77 69 6c 6c 20 6e 6f 74 69 63 65 0a 74 68 |u will notice.th| 00001e10 61 74 20 74 68 65 20 69 63 6f 6e 20 74 6f 20 74 |at the icon to t| 00001e20 68 65 20 6c 65 66 74 20 6f 66 20 74 68 65 20 27 |he left of the '| 00001e30 4f 4b 27 20 62 75 74 74 6f 6e 20 64 69 73 70 6c |OK' button displ| 00001e40 61 79 73 20 74 68 65 20 6e 75 6d 62 65 72 20 6f |ays the number o| 00001e50 66 20 6d 61 74 63 68 65 73 0a 66 6f 75 6e 64 2e |f matches.found.| 00001e60 0a 0a 54 68 65 20 69 6e 64 65 78 20 62 65 69 6e |..The index bein| 00001e70 67 20 73 65 61 72 63 68 65 64 20 69 73 20 64 69 |g searched is di| 00001e80 73 70 6c 61 79 65 64 20 6f 6e 20 74 68 65 20 65 |splayed on the e| 00001e90 78 70 61 6e 64 65 64 20 6b 65 79 70 61 64 2e 20 |xpanded keypad. | 00001ea0 50 72 6f 76 69 64 65 64 20 74 68 65 0a 64 61 74 |Provided the.dat| 00001eb0 61 62 61 73 65 20 75 73 65 73 20 61 74 20 6c 65 |abase uses at le| 00001ec0 61 73 74 20 6f 6e 65 20 73 75 62 73 69 64 69 61 |ast one subsidia| 00001ed0 72 79 20 6b 65 79 20 79 6f 75 20 77 69 6c 6c 20 |ry key you will | 00001ee0 73 65 65 20 69 74 20 63 68 61 6e 67 65 20 61 73 |see it change as| 00001ef0 20 79 6f 75 0a 63 6c 69 63 6b 20 6f 6e 20 65 69 | you.click on ei| 00001f00 74 68 65 72 20 6f 66 20 74 68 65 20 22 43 68 61 |ther of the "Cha| 00001f10 6e 67 65 20 6b 65 79 22 20 62 75 74 74 6f 6e 73 |nge key" buttons| 00001f20 2e 0a 0a 41 73 20 64 65 73 63 72 69 62 65 64 20 |...As described | 00001f30 61 62 6f 76 65 20 74 68 65 20 22 53 65 61 72 63 |above the "Searc| 00001f40 68 22 20 66 75 6e 63 74 69 6f 6e 20 73 65 61 72 |h" function sear| 00001f50 63 68 65 73 20 6f 6e 6c 79 20 74 68 65 20 63 75 |ches only the cu| 00001f60 72 72 65 6e 74 20 73 75 62 66 69 6c 65 2e 0a 49 |rrent subfile..I| 00001f70 66 20 79 6f 75 20 73 75 73 70 65 63 74 20 74 68 |f you suspect th| 00001f80 61 74 20 74 68 65 20 72 65 63 6f 72 64 20 79 6f |at the record yo| 00001f90 75 20 72 65 71 75 69 72 65 20 6d 69 67 68 74 20 |u require might | 00001fa0 62 65 20 6c 75 72 6b 69 6e 67 20 69 6e 20 73 6f |be lurking in so| 00001fb0 6d 65 20 6f 74 68 65 72 0a 73 75 62 66 69 6c 65 |me other.subfile| 00001fc0 20 79 6f 75 20 63 61 6e 20 66 6f 72 63 65 20 61 | you can force a| 00001fd0 6c 6c 20 73 69 78 20 74 6f 20 62 65 20 73 65 61 |ll six to be sea| 00001fe0 72 63 68 65 64 2e 20 54 68 69 73 20 63 61 6e 20 |rched. This can | 00001ff0 62 65 20 61 63 68 69 65 76 65 64 20 62 79 20 75 |be achieved by u| 00002000 73 69 6e 67 0a 41 44 4a 55 53 54 20 28 6b 65 79 |sing.ADJUST (key| 00002010 73 74 72 6f 6b 65 20 65 71 75 69 76 61 6c 65 6e |stroke equivalen| 00002020 74 20 53 48 2f 66 31 29 20 69 6e 73 74 65 61 64 |t SH/f1) instead| 00002030 20 6f 66 20 53 45 4c 45 43 54 20 6f 6e 20 74 68 | of SELECT on th| 00002040 65 20 22 53 65 61 72 63 68 22 20 62 75 74 74 6f |e "Search" butto| 00002050 6e 0a 6f 72 2c 20 61 66 74 65 72 20 74 68 65 20 |n.or, after the | 00002060 6b 65 79 70 61 64 20 68 61 73 20 65 78 70 61 6e |keypad has expan| 00002070 64 65 64 2c 20 62 79 20 63 68 61 6e 67 69 6e 67 |ded, by changing| 00002080 20 74 68 65 20 73 65 6c 65 63 74 65 64 20 72 61 | the selected ra| 00002090 64 69 6f 20 62 75 74 74 6f 6e 0a 66 72 6f 6d 20 |dio button.from | 000020a0 74 68 65 20 66 69 72 73 74 20 74 6f 20 74 68 65 |the first to the| 000020b0 20 73 65 63 6f 6e 64 2e 20 49 66 20 74 68 65 20 | second. If the | 000020c0 72 65 63 6f 72 64 20 69 73 20 66 6f 75 6e 64 20 |record is found | 000020d0 69 6e 20 73 6f 6d 65 20 6f 74 68 65 72 20 73 75 |in some other su| 000020e0 62 66 69 6c 65 0a 74 68 65 6e 20 74 68 61 74 20 |bfile.then that | 000020f0 73 75 62 66 69 6c 65 20 77 69 6c 6c 20 62 65 20 |subfile will be | 00002100 6d 61 64 65 20 74 68 65 20 63 75 72 72 65 6e 74 |made the current| 00002110 20 6f 6e 65 20 61 6e 64 20 74 68 65 20 72 65 63 | one and the rec| 00002120 6f 72 64 20 64 69 73 70 6c 61 79 65 64 2e 0a 0a |ord displayed...| 00002130 49 66 20 73 65 61 72 63 68 69 6e 67 20 6f 6e 20 |If searching on | 00002140 61 20 6e 75 6d 65 72 69 63 20 6b 65 79 20 79 6f |a numeric key yo| 00002150 75 20 77 69 6c 6c 20 6f 6e 6c 79 20 66 69 6e 64 |u will only find| 00002160 20 74 68 65 20 72 65 63 6f 72 64 20 62 79 20 65 | the record by e| 00002170 6e 74 65 72 69 6e 67 20 61 0a 6e 75 6d 62 65 72 |ntering a.number| 00002180 20 6f 66 20 65 78 61 63 74 6c 79 20 74 68 65 20 | of exactly the | 00002190 72 69 67 68 74 20 76 61 6c 75 65 2e 20 49 66 20 |right value. If | 000021a0 74 68 65 20 6b 65 79 20 69 73 20 61 6c 70 68 61 |the key is alpha| 000021b0 62 65 74 69 63 2c 20 68 6f 77 65 76 65 72 2c 20 |betic, however, | 000021c0 79 6f 75 0a 6d 61 79 20 75 73 65 20 6a 75 73 74 |you.may use just| 000021d0 20 74 68 65 20 66 69 72 73 74 20 66 65 77 20 6c | the first few l| 000021e0 65 74 74 65 72 73 20 69 66 20 74 68 65 79 20 61 |etters if they a| 000021f0 72 65 20 73 75 66 66 69 63 69 65 6e 74 20 74 6f |re sufficient to| 00002200 20 64 69 73 74 69 6e 67 75 69 73 68 20 74 68 65 | distinguish the| 00002210 0a 6b 65 79 20 66 72 6f 6d 20 6f 74 68 65 72 73 |.key from others| 00002220 2e 0a 0a 53 65 61 72 63 68 69 6e 67 20 62 79 20 |...Searching by | 00002230 72 65 63 6f 72 64 20 6e 75 6d 62 65 72 0a 2d 2d |record number.--| 00002240 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------| 00002250 2d 2d 2d 2d 2d 2d 2d 2d 0a 59 6f 75 20 6d 61 79 |--------.You may| 00002260 20 74 79 70 65 20 61 20 72 65 63 6f 72 64 20 6e | type a record n| 00002270 75 6d 62 65 72 2c 20 70 72 65 63 65 64 65 64 20 |umber, preceded | 00002280 62 79 20 23 2c 20 28 65 2e 67 2e 20 23 31 30 35 |by #, (e.g. #105| 00002290 34 29 20 69 6e 73 74 65 61 64 20 6f 66 20 61 20 |4) instead of a | 000022a0 6b 65 79 2e 0a 50 72 6f 76 69 64 65 64 20 74 68 |key..Provided th| 000022b0 65 20 72 65 63 6f 72 64 20 69 73 20 69 6e 20 75 |e record is in u| 000022c0 73 65 20 50 6f 77 65 72 62 61 73 65 20 77 69 6c |se Powerbase wil| 000022d0 6c 20 66 69 6e 64 20 61 6e 64 20 64 69 73 70 6c |l find and displ| 000022e0 61 79 20 69 74 2c 20 72 65 67 61 72 64 6c 65 73 |ay it, regardles| 000022f0 73 0a 6f 66 20 77 68 61 74 20 73 75 62 66 69 6c |s.of what subfil| 00002300 65 20 69 74 20 69 73 20 69 6e 2e 20 49 66 20 74 |e it is in. If t| 00002310 68 65 20 72 65 63 6f 72 64 20 68 61 73 20 62 65 |he record has be| 00002320 65 6e 20 64 65 6c 65 74 65 64 20 6f 72 20 68 61 |en deleted or ha| 00002330 73 20 6e 65 76 65 72 20 62 65 65 6e 0a 61 73 73 |s never been.ass| 00002340 69 67 6e 65 64 20 61 20 22 52 65 63 6f 72 64 20 |igned a "Record | 00002350 6e 6f 74 20 69 6e 20 75 73 65 22 20 65 72 72 6f |not in use" erro| 00002360 72 20 69 73 20 67 65 6e 65 72 61 74 65 64 2e 0a |r is generated..| 00002370 0a 53 65 61 72 63 68 69 6e 67 20 62 79 20 66 69 |.Searching by fi| 00002380 6c 74 65 72 0a 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |lter.-----------| 00002390 2d 2d 2d 2d 2d 2d 2d 2d 0a 49 6e 20 74 68 65 20 |--------.In the | 000023a0 6d 69 64 64 6c 65 20 6f 66 20 74 68 65 20 6c 61 |middle of the la| 000023b0 73 74 20 72 6f 77 20 6f 6e 20 74 68 65 20 6b 65 |st row on the ke| 000023c0 79 70 61 64 20 69 73 20 74 68 65 20 22 46 69 6c |ypad is the "Fil| 000023d0 74 65 72 22 20 62 75 74 74 6f 6e 2e 20 57 68 65 |ter" button. Whe| 000023e0 6e 0a 63 6c 69 63 6b 65 64 20 74 68 65 20 6b 65 |n.clicked the ke| 000023f0 79 70 61 64 20 65 78 70 61 6e 64 73 20 64 6f 77 |ypad expands dow| 00002400 6e 77 61 72 64 73 20 72 65 76 65 61 6c 69 6e 67 |nwards revealing| 00002410 20 61 20 77 72 69 74 61 62 6c 65 20 69 63 6f 6e | a writable icon| 00002420 20 69 6e 74 6f 20 77 68 69 63 68 0a 79 6f 75 20 | into which.you | 00002430 63 61 6e 20 74 79 70 65 20 61 20 53 65 61 72 63 |can type a Searc| 00002440 68 20 46 6f 72 6d 75 6c 61 20 66 6f 6c 6c 6f 77 |h Formula follow| 00002450 65 64 20 62 79 20 63 6c 69 63 6b 69 6e 67 20 6f |ed by clicking o| 00002460 6e 20 27 4f 4b 27 20 6f 72 20 74 79 70 69 6e 67 |n 'OK' or typing| 00002470 20 52 45 54 55 52 4e 2e 0a 28 53 65 65 20 27 50 | RETURN..(See 'P| 00002480 72 69 6e 74 69 6e 67 27 20 66 6f 72 20 61 6e 20 |rinting' for an | 00002490 65 78 70 6c 61 6e 61 74 69 6f 6e 20 6f 66 20 73 |explanation of s| 000024a0 65 61 72 63 68 20 66 6f 72 6d 75 6c 61 65 2e 29 |earch formulae.)| 000024b0 20 54 68 65 20 6b 65 79 70 61 64 20 62 75 74 74 | The keypad butt| 000024c0 6f 6e 73 0a 75 73 65 64 20 66 6f 72 20 62 72 6f |ons.used for bro| 000024d0 77 73 69 6e 67 20 77 69 6c 6c 20 6e 6f 77 20 6f |wsing will now o| 000024e0 6e 6c 79 20 64 69 73 70 6c 61 79 20 72 65 63 6f |nly display reco| 000024f0 72 64 73 20 77 68 69 63 68 20 6d 61 74 63 68 20 |rds which match | 00002500 74 68 65 20 73 65 61 72 63 68 0a 66 6f 72 6d 75 |the search.formu| 00002510 6c 61 2c 20 61 6c 6c 20 6e 6f 6e 2d 6d 61 74 63 |la, all non-matc| 00002520 68 69 6e 67 20 72 65 63 6f 72 64 73 20 62 65 69 |hing records bei| 00002530 6e 67 20 22 66 69 6c 74 65 72 65 64 20 6f 75 74 |ng "filtered out| 00002540 22 2e 20 54 68 65 20 6d 61 74 63 68 20 69 73 20 |". The match is | 00002550 63 61 73 65 0a 73 70 65 63 69 66 69 63 20 62 79 |case.specific by| 00002560 20 64 65 66 61 75 6c 74 20 62 75 74 20 6d 61 79 | default but may| 00002570 20 62 65 20 6d 61 64 65 20 6e 6f 6e 2d 73 70 65 | be made non-spe| 00002580 63 69 66 69 63 20 62 79 20 64 65 2d 73 65 6c 65 |cific by de-sele| 00002590 63 74 69 6e 67 20 74 68 65 20 6f 70 74 69 6f 6e |cting the option| 000025a0 0a 73 77 69 74 63 68 20 6f 6e 20 74 68 65 20 6b |.switch on the k| 000025b0 65 79 70 61 64 20 65 78 74 65 6e 73 69 6f 6e 2e |eypad extension.| 000025c0 0a 0a 44 65 73 65 6c 65 63 74 69 6e 67 20 74 68 |..Deselecting th| 000025d0 65 20 22 46 69 6c 74 65 72 22 20 73 77 69 74 63 |e "Filter" switc| 000025e0 68 20 72 65 73 74 6f 72 65 73 20 74 68 65 20 6b |h restores the k| 000025f0 65 79 70 61 64 20 74 6f 20 69 74 73 20 6e 6f 72 |eypad to its nor| 00002600 6d 61 6c 20 61 70 70 65 61 72 61 6e 63 65 0a 61 |mal appearance.a| 00002610 6e 64 20 6f 70 65 72 61 74 69 6f 6e 2e 0a 0a 45 |nd operation...E| 00002620 64 69 74 69 6e 67 20 74 68 65 20 64 61 74 61 62 |diting the datab| 00002630 61 73 65 0a 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |ase.============| 00002640 3d 3d 3d 3d 3d 3d 3d 3d 0a 0a 41 64 64 69 6e 67 |========..Adding| 00002650 20 6e 65 77 20 72 65 63 6f 72 64 73 0a 2d 2d 2d | new records.---| 00002660 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a |---------------.| 00002670 54 68 65 20 69 63 6f 6e 20 62 65 61 72 69 6e 67 |The icon bearing| 00002680 20 61 20 72 65 63 6f 72 64 20 63 61 72 64 20 61 | a record card a| 00002690 6e 64 20 61 20 70 6c 75 73 20 73 69 67 6e 20 69 |nd a plus sign i| 000026a0 73 20 74 68 65 20 22 41 64 64 20 72 65 63 6f 72 |s the "Add recor| 000026b0 64 22 20 62 75 74 74 6f 6e 0a 28 6b 65 79 73 74 |d" button.(keyst| 000026c0 72 6f 6b 65 20 65 71 75 69 76 61 6c 65 6e 74 20 |roke equivalent | 000026d0 66 31 30 29 2e 20 43 6c 69 63 6b 69 6e 67 20 77 |f10). Clicking w| 000026e0 69 74 68 20 53 45 4c 45 43 54 20 64 69 73 70 6c |ith SELECT displ| 000026f0 61 79 73 20 61 20 62 6c 61 6e 6b 20 72 65 63 6f |ays a blank reco| 00002700 72 64 20 66 6f 72 0a 79 6f 75 20 74 6f 20 66 69 |rd for.you to fi| 00002710 6c 6c 20 69 6e 20 61 6e 64 20 74 68 65 20 77 69 |ll in and the wi| 00002720 6e 64 6f 77 20 74 69 74 6c 65 20 73 61 79 73 20 |ndow title says | 00002730 22 4e 65 77 20 72 65 63 6f 72 64 22 2e 20 54 68 |"New record". Th| 00002740 65 20 6f 6e 6c 79 20 66 69 65 6c 64 20 77 68 69 |e only field whi| 00002750 63 68 0a 79 6f 75 20 4d 55 53 54 20 66 69 6c 6c |ch.you MUST fill| 00002760 20 69 6e 20 69 73 20 74 68 65 20 70 72 69 6d 61 | in is the prima| 00002770 72 79 20 6b 65 79 20 66 69 65 6c 64 2e 20 41 6e |ry key field. An| 00002780 79 20 6f 72 20 61 6c 6c 20 6f 66 20 74 68 65 20 |y or all of the | 00002790 72 65 73 74 20 6f 66 20 74 68 65 0a 66 69 65 6c |rest of the.fiel| 000027a0 64 73 20 28 69 6e 63 6c 75 64 69 6e 67 20 73 75 |ds (including su| 000027b0 62 73 69 64 69 61 72 79 20 6b 65 79 20 66 69 65 |bsidiary key fie| 000027c0 6c 64 73 29 20 6d 61 79 20 62 65 20 6c 65 66 74 |lds) may be left| 000027d0 20 62 6c 61 6e 6b 2e 20 59 6f 75 20 6d 61 79 20 | blank. You may | 000027e0 66 69 6e 64 20 6f 6e 0a 73 6f 6d 65 20 66 69 65 |find on.some fie| 000027f0 6c 64 73 20 74 68 61 74 20 74 68 65 20 6b 65 79 |lds that the key| 00002800 73 20 79 6f 75 20 70 72 65 73 73 20 77 69 6c 6c |s you press will| 00002810 20 68 61 76 65 20 6e 6f 20 65 66 66 65 63 74 2e | have no effect.| 00002820 20 54 68 69 73 20 77 69 6c 6c 20 68 61 70 70 65 | This will happe| 00002830 6e 2c 0a 66 6f 72 20 65 78 61 6d 70 6c 65 2c 20 |n,.for example, | 00002840 69 66 20 79 6f 75 20 74 72 79 20 74 6f 20 74 79 |if you try to ty| 00002850 70 65 20 6c 65 74 74 65 72 73 20 69 6e 74 6f 20 |pe letters into | 00002860 61 20 66 69 65 6c 64 20 77 68 69 63 68 20 68 61 |a field which ha| 00002870 73 20 62 65 65 6e 20 64 65 66 69 6e 65 64 0a 61 |s been defined.a| 00002880 73 20 6e 75 6d 65 72 69 63 2e 20 0a 0a 49 66 20 |s numeric. ..If | 00002890 79 6f 75 20 74 79 70 65 20 69 6e 74 6f 20 61 20 |you type into a | 000028a0 66 69 65 6c 64 20 77 68 69 63 68 20 69 73 20 68 |field which is h| 000028b0 69 67 68 6c 69 67 68 74 65 64 20 69 6e 20 64 61 |ighlighted in da| 000028c0 72 6b 20 67 72 65 65 6e 20 79 6f 75 20 6d 61 79 |rk green you may| 000028d0 20 67 65 74 20 61 6e 0a 65 72 72 6f 72 20 6d 65 | get an.error me| 000028e0 73 73 61 67 65 2e 20 53 75 63 68 20 66 69 65 6c |ssage. Such fiel| 000028f0 64 73 20 77 69 6c 6c 20 6f 6e 6c 79 20 61 63 63 |ds will only acc| 00002900 65 70 74 20 63 65 72 74 61 69 6e 20 22 76 61 6c |ept certain "val| 00002910 75 65 73 22 20 77 68 69 63 68 20 61 72 65 0a 6c |ues" which are.l| 00002920 69 73 74 65 64 20 69 6e 20 61 20 56 61 6c 69 64 |isted in a Valid| 00002930 61 74 69 6f 6e 20 54 61 62 6c 65 20 28 73 65 65 |ation Table (see| 00002940 20 27 56 61 6c 69 64 61 74 69 6f 6e 27 29 2e 20 | 'Validation'). | 00002950 54 6f 20 73 65 65 20 77 68 61 74 20 74 68 65 73 |To see what thes| 00002960 65 20 61 6c 6c 6f 77 65 64 0a 76 61 6c 75 65 73 |e allowed.values| 00002970 20 61 72 65 20 6d 61 6b 65 20 73 75 72 65 20 74 | are make sure t| 00002980 68 65 20 63 61 72 65 74 20 69 73 20 69 6e 20 74 |he caret is in t| 00002990 68 65 20 72 65 6c 65 76 61 6e 74 20 66 69 65 6c |he relevant fiel| 000029a0 64 20 74 68 65 6e 20 63 6c 69 63 6b 20 6f 6e 20 |d then click on | 000029b0 74 68 65 0a 22 4c 69 73 74 20 76 61 6c 75 65 73 |the."List values| 000029c0 22 20 62 75 74 74 6f 6e 20 6f 6e 20 74 68 65 20 |" button on the | 000029d0 6b 65 79 70 61 64 20 28 6b 65 79 73 74 72 6f 6b |keypad (keystrok| 000029e0 65 20 65 71 75 69 76 61 6c 65 6e 74 20 66 38 29 |e equivalent f8)| 000029f0 2e 20 49 66 20 74 68 65 20 74 61 62 6c 65 0a 76 |. If the table.v| 00002a00 61 6c 69 64 61 74 69 6f 6e 20 66 65 61 74 75 72 |alidation featur| 00002a10 65 20 70 72 6f 76 65 73 20 74 6f 20 62 65 20 61 |e proves to be a| 00002a20 20 6e 75 69 73 61 6e 63 65 20 79 6f 75 20 63 61 | nuisance you ca| 00002a30 6e 20 74 75 72 6e 20 69 74 20 6f 6e 20 61 6e 64 |n turn it on and| 00002a40 20 6f 66 66 20 77 69 74 68 0a 74 68 65 20 27 56 | off with.the 'V| 00002a50 61 6c 69 64 61 74 65 20 69 6e 70 75 74 27 20 65 |alidate input' e| 00002a60 6e 74 72 79 20 6f 6e 20 74 68 65 20 27 56 61 6c |ntry on the 'Val| 00002a70 69 64 61 74 69 6f 6e 27 20 73 75 62 6d 65 6e 75 |idation' submenu| 00002a80 2e 20 49 66 20 74 68 65 20 65 6e 74 72 79 20 69 |. If the entry i| 00002a90 73 0a 74 69 63 6b 65 64 20 74 68 65 6e 20 76 61 |s.ticked then va| 00002aa0 6c 69 64 61 74 69 6f 6e 20 69 73 20 22 6f 6e 22 |lidation is "on"| 00002ab0 20 28 6b 65 79 73 74 72 6f 6b 65 20 65 71 75 69 | (keystroke equi| 00002ac0 76 61 6c 65 6e 74 20 53 48 2f 66 38 29 2e 0a 0a |valent SH/f8)...| 00002ad0 57 68 65 6e 20 79 6f 75 20 68 61 76 65 20 65 6e |When you have en| 00002ae0 74 65 72 65 64 20 61 73 20 6d 75 63 68 20 6f 66 |tered as much of| 00002af0 20 61 20 72 65 63 6f 72 64 20 61 73 20 79 6f 75 | a record as you| 00002b00 20 77 61 6e 74 20 74 6f 20 79 6f 75 20 63 61 6e | want to you can| 00002b10 20 63 6c 69 63 6b 20 22 41 64 64 0a 72 65 63 6f | click "Add.reco| 00002b20 72 64 22 20 61 67 61 69 6e 20 66 6f 72 20 61 6e |rd" again for an| 00002b30 6f 74 68 65 72 20 62 6c 61 6e 6b 20 72 65 63 6f |other blank reco| 00002b40 72 64 2e 20 54 68 65 20 72 65 63 6f 72 64 20 77 |rd. The record w| 00002b50 68 69 63 68 20 79 6f 75 20 68 61 76 65 20 6a 75 |hich you have ju| 00002b60 73 74 0a 65 6e 74 65 72 65 64 20 69 73 20 61 75 |st.entered is au| 00002b70 74 6f 6d 61 74 69 63 61 6c 6c 79 20 77 72 69 74 |tomatically writ| 00002b80 74 65 6e 20 74 6f 20 74 68 65 20 66 69 6c 65 2e |ten to the file.| 00002b90 20 54 68 65 20 73 61 6d 65 20 69 73 20 74 72 75 | The same is tru| 00002ba0 65 20 69 66 20 79 6f 75 20 63 6c 69 63 6b 0a 61 |e if you click.a| 00002bb0 6e 79 20 6f 66 20 74 68 65 20 6f 74 68 65 72 20 |ny of the other | 00002bc0 6b 65 79 70 61 64 20 62 75 74 74 6f 6e 73 20 6f |keypad buttons o| 00002bd0 72 20 63 6c 6f 73 65 20 74 68 65 20 64 61 74 61 |r close the data| 00002be0 62 61 73 65 20 61 6c 74 6f 67 65 74 68 65 72 20 |base altogether | 00002bf0 2d 20 79 6f 75 20 6e 65 76 65 72 0a 6e 65 65 64 |- you never.need| 00002c00 20 74 6f 20 64 6f 20 61 6e 79 74 68 69 6e 67 20 | to do anything | 00002c10 74 6f 20 22 74 65 6c 6c 22 20 50 6f 77 65 72 62 |to "tell" Powerb| 00002c20 61 73 65 20 74 6f 20 75 70 64 61 74 65 20 74 68 |ase to update th| 00002c30 65 20 66 69 6c 65 2e 20 54 68 65 72 65 20 69 73 |e file. There is| 00002c40 20 69 6e 64 65 65 64 0a 61 20 62 75 74 74 6f 6e | indeed.a button| 00002c50 20 63 61 6c 6c 65 64 20 22 46 6f 72 63 65 20 75 | called "Force u| 00002c60 70 64 61 74 65 22 20 62 75 74 20 79 6f 75 20 64 |pdate" but you d| 00002c70 6f 6e 27 74 20 72 65 61 6c 6c 79 20 6e 65 65 64 |on't really need| 00002c80 20 74 6f 20 75 73 65 20 69 74 2e 20 49 74 20 69 | to use it. It i| 00002c90 73 0a 70 72 6f 76 69 64 65 64 20 73 6f 20 74 68 |s.provided so th| 00002ca0 61 74 2c 20 64 75 72 69 6e 67 20 61 20 6c 6f 6e |at, during a lon| 00002cb0 67 20 77 6f 72 6b 69 6e 67 20 73 65 73 73 69 6f |g working sessio| 00002cc0 6e 2c 20 79 6f 75 20 63 61 6e 20 66 6f 72 63 65 |n, you can force| 00002cd0 20 50 6f 77 65 72 62 61 73 65 20 74 6f 0a 73 61 | Powerbase to.sa| 00002ce0 76 65 20 74 6f 20 64 69 73 63 20 63 65 72 74 61 |ve to disc certa| 00002cf0 69 6e 20 69 74 65 6d 73 20 28 69 6e 64 69 63 65 |in items (indice| 00002d00 73 20 61 6e 64 20 76 61 6c 69 64 61 74 69 6f 6e |s and validation| 00002d10 20 74 61 62 6c 65 73 29 20 77 68 69 63 68 20 61 | tables) which a| 00002d20 72 65 20 6b 65 70 74 20 69 6e 0a 6d 65 6d 6f 72 |re kept in.memor| 00002d30 79 20 77 68 69 6c 65 20 50 6f 77 65 72 62 61 73 |y while Powerbas| 00002d40 65 20 69 73 20 72 75 6e 6e 69 6e 67 2e 20 54 68 |e is running. Th| 00002d50 69 73 20 69 73 20 74 6f 20 67 75 61 72 64 20 61 |is is to guard a| 00002d60 67 61 69 6e 73 74 20 61 20 70 6f 77 65 72 20 63 |gainst a power c| 00002d70 75 74 20 6f 72 0a 73 79 73 74 65 6d 20 66 61 69 |ut or.system fai| 00002d80 6c 75 72 65 20 28 73 75 63 68 20 61 73 20 73 6f |lure (such as so| 00002d90 6d 65 20 6b 69 6e 64 20 70 65 72 73 6f 6e 20 73 |me kind person s| 00002da0 77 69 74 63 68 69 6e 67 20 79 6f 75 72 20 63 6f |witching your co| 00002db0 6d 70 75 74 65 72 20 6f 66 66 20 66 6f 72 20 79 |mputer off for y| 00002dc0 6f 75 0a 77 68 65 6e 20 79 6f 75 27 76 65 20 6a |ou.when you've j| 00002dd0 75 73 74 20 70 6f 70 70 65 64 20 6f 75 74 20 66 |ust popped out f| 00002de0 6f 72 20 61 20 6d 69 6e 75 74 65 21 29 2e 0a 0a |or a minute!)...| 00002df0 55 73 69 6e 67 20 61 20 74 65 6d 70 6c 61 74 65 |Using a template| 00002e00 0a 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |.---------------| 00002e10 2d 0a 53 6f 6d 65 74 69 6d 65 73 20 79 6f 75 20 |-.Sometimes you | 00002e20 77 61 6e 74 20 63 65 72 74 61 69 6e 20 66 69 65 |want certain fie| 00002e30 6c 64 73 20 74 6f 20 62 65 20 66 69 6c 6c 65 64 |lds to be filled| 00002e40 20 69 6e 20 77 69 74 68 20 61 20 66 69 78 65 64 | in with a fixed| 00002e50 20 76 61 6c 75 65 20 6f 6e 0a 65 76 65 72 79 20 | value on.every | 00002e60 6e 65 77 20 72 65 63 6f 72 64 2e 20 54 6f 20 73 |new record. To s| 00002e70 61 76 65 20 79 6f 75 20 74 79 70 69 6e 67 20 74 |ave you typing t| 00002e80 68 65 20 73 61 6d 65 20 74 68 69 6e 67 20 69 6e |he same thing in| 00002e90 74 6f 20 74 68 65 20 73 61 6d 65 20 66 69 65 6c |to the same fiel| 00002ea0 64 0a 65 76 65 72 79 20 74 69 6d 65 2c 20 50 6f |d.every time, Po| 00002eb0 77 65 72 62 61 73 65 20 70 72 6f 76 69 64 65 73 |werbase provides| 00002ec0 20 61 6e 20 22 45 64 69 74 20 74 65 6d 70 6c 61 | an "Edit templa| 00002ed0 74 65 22 20 66 75 6e 63 74 69 6f 6e 20 77 68 69 |te" function whi| 00002ee0 63 68 20 69 73 0a 61 63 63 65 73 73 69 62 6c 65 |ch is.accessible| 00002ef0 20 66 72 6f 6d 20 74 68 65 20 27 4d 69 73 63 65 | from the 'Misce| 00002f00 6c 6c 61 6e 65 6f 75 73 27 20 73 75 62 6d 65 6e |llaneous' submen| 00002f10 75 2e 20 57 68 65 6e 20 79 6f 75 20 63 68 6f 6f |u. When you choo| 00002f20 73 65 20 74 68 69 73 20 79 6f 75 20 61 72 65 0a |se this you are.| 00002f30 70 72 65 73 65 6e 74 65 64 20 77 69 74 68 20 61 |presented with a| 00002f40 20 62 6c 61 6e 6b 20 72 65 63 6f 72 64 20 61 6e | blank record an| 00002f50 64 20 74 68 65 20 77 69 6e 64 6f 77 20 74 69 74 |d the window tit| 00002f60 6c 65 20 73 61 79 73 20 22 45 6e 74 65 72 20 64 |le says "Enter d| 00002f70 61 74 61 20 77 68 69 63 68 0a 79 6f 75 20 77 69 |ata which.you wi| 00002f80 73 68 20 74 6f 20 61 70 70 65 61 72 20 62 79 20 |sh to appear by | 00002f90 64 65 66 61 75 6c 74 20 6f 6e 20 6e 65 77 20 72 |default on new r| 00002fa0 65 63 6f 72 64 73 22 2e 20 54 79 70 65 20 69 6e |ecords". Type in| 00002fb0 20 74 68 65 20 72 65 71 75 69 72 65 64 20 22 66 | the required "f| 00002fc0 69 78 65 64 22 0a 64 61 74 61 20 74 68 65 6e 20 |ixed".data then | 00002fd0 63 6c 69 63 6b 20 61 6e 79 20 6f 66 20 74 68 65 |click any of the| 00002fe0 20 75 73 75 61 6c 20 6b 65 79 70 61 64 20 62 75 | usual keypad bu| 00002ff0 74 74 6f 6e 73 2e 20 59 6f 75 20 77 69 6c 6c 20 |ttons. You will | 00003000 6e 6f 77 20 66 69 6e 64 20 74 68 61 74 20 74 68 |now find that th| 00003010 65 0a 22 62 6c 61 6e 6b 22 20 72 65 63 6f 72 64 |e."blank" record| 00003020 20 64 69 73 70 6c 61 79 65 64 20 65 76 65 72 20 | displayed ever | 00003030 74 69 6d 65 20 79 6f 75 20 63 6c 69 63 6b 20 22 |time you click "| 00003040 41 64 64 20 72 65 63 6f 72 64 22 20 28 66 31 30 |Add record" (f10| 00003050 29 20 69 73 6e 27 74 20 72 65 61 6c 6c 79 0a 62 |) isn't really.b| 00003060 6c 61 6e 6b 20 61 74 20 61 6c 6c 20 62 75 74 20 |lank at all but | 00003070 61 6c 72 65 61 64 79 20 63 6f 6e 74 61 69 6e 73 |already contains| 00003080 20 74 68 65 20 64 61 74 61 20 65 6e 74 65 72 65 | the data entere| 00003090 64 20 69 6e 20 79 6f 75 72 20 74 65 6d 70 6c 61 |d in your templa| 000030a0 74 65 2e 20 4e 6f 74 65 0a 74 68 61 74 20 74 68 |te. Note.that th| 000030b0 69 73 20 66 65 61 74 75 72 65 20 61 66 66 65 63 |is feature affec| 000030c0 74 73 20 4e 45 57 20 72 65 63 6f 72 64 73 20 6f |ts NEW records o| 000030d0 6e 6c 79 2e 20 49 74 20 64 6f 65 73 6e 27 74 20 |nly. It doesn't | 000030e0 68 61 76 65 20 61 20 72 65 74 72 6f 73 70 65 63 |have a retrospec| 000030f0 74 69 76 65 0a 65 66 66 65 63 74 20 6f 6e 20 65 |tive.effect on e| 00003100 78 69 73 74 69 6e 67 20 72 65 63 6f 72 64 73 2e |xisting records.| 00003110 0a 0a 55 73 69 6e 67 20 74 68 65 20 63 6c 69 70 |..Using the clip| 00003120 62 6f 61 72 64 0a 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |board.----------| 00003130 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a 54 68 65 20 62 75 |---------.The bu| 00003140 74 74 6f 6e 73 20 61 74 20 74 68 65 20 66 61 72 |ttons at the far| 00003150 20 6c 65 66 74 20 61 6e 64 20 72 69 67 68 74 20 | left and right | 00003160 6f 66 20 74 68 65 20 6d 69 64 64 6c 65 20 72 6f |of the middle ro| 00003170 77 20 6f 66 20 74 68 65 20 6b 65 79 70 61 64 20 |w of the keypad | 00003180 6d 61 79 20 62 65 0a 74 68 6f 75 67 68 74 20 6f |may be.thought o| 00003190 66 20 61 73 20 22 49 63 6f 6e 20 74 6f 20 63 6c |f as "Icon to cl| 000031a0 69 70 62 6f 61 72 64 22 20 61 6e 64 20 22 43 6c |ipboard" and "Cl| 000031b0 69 70 62 6f 61 72 64 20 74 6f 20 69 63 6f 6e 22 |ipboard to icon"| 000031c0 20 72 65 73 70 65 63 74 69 76 65 6c 79 2e 20 54 | respectively. T| 000031d0 68 65 79 0a 63 61 6e 20 73 61 76 65 20 63 6f 6e |hey.can save con| 000031e0 73 69 64 65 72 61 62 6c 65 20 74 69 6d 65 20 77 |siderable time w| 000031f0 68 65 6e 20 79 6f 75 20 77 61 6e 74 20 74 6f 20 |hen you want to | 00003200 63 6f 70 79 20 64 61 74 61 20 66 72 6f 6d 20 6f |copy data from o| 00003210 6e 65 20 66 69 65 6c 64 20 69 6e 74 6f 0a 61 6e |ne field into.an| 00003220 6f 74 68 65 72 2c 20 77 68 65 74 68 65 72 20 69 |other, whether i| 00003230 6e 20 74 68 65 20 73 61 6d 65 20 72 65 63 6f 72 |n the same recor| 00003240 64 20 6f 72 20 69 6e 20 61 20 64 69 66 66 65 72 |d or in a differ| 00003250 65 6e 74 20 6f 6e 65 2e 20 57 68 65 6e 20 79 6f |ent one. When yo| 00003260 75 20 63 6c 69 63 6b 0a 53 45 4c 45 43 54 20 6f |u click.SELECT o| 00003270 6e 20 22 49 63 6f 6e 20 74 6f 20 63 6c 69 70 62 |n "Icon to clipb| 00003280 6f 61 72 64 22 20 74 68 65 20 63 6f 6e 74 65 6e |oard" the conten| 00003290 74 73 20 6f 66 20 74 68 65 20 66 69 65 6c 64 20 |ts of the field | 000032a0 77 68 69 63 68 20 68 61 73 20 74 68 65 20 63 61 |which has the ca| 000032b0 72 65 74 0a 61 72 65 20 73 74 6f 72 65 64 20 69 |ret.are stored i| 000032c0 6e 20 6d 65 6d 6f 72 79 2e 20 50 6f 73 69 74 69 |n memory. Positi| 000032d0 6f 6e 69 6e 67 20 74 68 65 20 63 61 72 65 74 20 |oning the caret | 000032e0 69 6e 20 61 6e 6f 74 68 65 72 20 66 69 65 6c 64 |in another field| 000032f0 20 61 6e 64 20 63 6c 69 63 6b 69 6e 67 20 6f 6e | and clicking on| 00003300 0a 22 43 6c 69 70 62 6f 61 72 64 20 74 6f 20 69 |."Clipboard to i| 00003310 63 6f 6e 22 20 77 69 6c 6c 20 63 6f 70 79 20 74 |con" will copy t| 00003320 68 65 20 73 74 6f 72 65 64 20 64 61 74 61 20 69 |he stored data i| 00003330 6e 74 6f 20 74 68 65 20 6e 65 77 20 66 69 65 6c |nto the new fiel| 00003340 64 2e 20 49 66 20 74 68 65 0a 64 61 74 61 20 69 |d. If the.data i| 00003350 73 20 74 6f 6f 20 6c 6f 6e 67 20 66 6f 72 20 74 |s too long for t| 00003360 68 65 20 66 69 65 6c 64 20 69 74 20 77 69 6c 6c |he field it will| 00003370 20 62 65 20 74 72 75 6e 63 61 74 65 64 20 74 6f | be truncated to| 00003380 20 66 69 74 2e 20 4f 6e 63 65 20 79 6f 75 20 68 | fit. Once you h| 00003390 61 76 65 0a 64 61 74 61 20 6f 6e 20 74 68 65 20 |ave.data on the | 000033a0 63 6c 69 70 62 6f 61 72 64 20 79 6f 75 20 6d 61 |clipboard you ma| 000033b0 79 20 63 6f 70 79 20 69 74 20 69 6e 74 6f 20 6f |y copy it into o| 000033c0 74 68 65 72 20 66 69 65 6c 64 73 20 61 73 20 6d |ther fields as m| 000033d0 61 6e 79 20 74 69 6d 65 73 20 61 73 20 79 6f 75 |any times as you| 000033e0 0a 77 69 73 68 20 2d 20 74 68 65 20 63 6c 69 70 |.wish - the clip| 000033f0 62 6f 61 72 64 20 63 6f 6e 74 65 6e 74 73 20 6f |board contents o| 00003400 6e 6c 79 20 63 68 61 6e 67 65 20 77 68 65 6e 20 |nly change when | 00003410 79 6f 75 20 63 6c 69 63 6b 20 6f 6e 20 22 49 63 |you click on "Ic| 00003420 6f 6e 20 74 6f 0a 63 6c 69 70 62 6f 61 72 64 22 |on to.clipboard"| 00003430 20 61 67 61 69 6e 2e 0a 0a 43 68 6f 6f 73 69 6e | again...Choosin| 00003440 67 20 77 68 65 72 65 20 74 68 65 20 63 61 72 65 |g where the care| 00003450 74 20 73 74 61 72 74 73 0a 2d 2d 2d 2d 2d 2d 2d |t starts.-------| 00003460 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------| 00003470 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a 57 68 65 6e 20 61 |---------.When a| 00003480 6e 20 65 78 69 73 74 69 6e 67 20 6f 72 20 62 6c |n existing or bl| 00003490 61 6e 6b 20 72 65 63 6f 72 64 20 69 73 20 64 69 |ank record is di| 000034a0 73 70 6c 61 79 65 64 20 50 6f 77 65 72 62 61 73 |splayed Powerbas| 000034b0 65 20 70 6c 61 63 65 73 20 74 68 65 20 63 61 72 |e places the car| 000034c0 65 74 20 69 6e 0a 74 68 65 20 66 69 72 73 74 20 |et in.the first | 000034d0 65 64 69 74 61 62 6c 65 20 66 69 65 6c 64 20 6f |editable field o| 000034e0 66 20 74 68 65 20 72 65 63 6f 72 64 2e 20 28 54 |f the record. (T| 000034f0 68 69 73 2c 20 69 6e 63 69 64 65 6e 74 61 6c 6c |his, incidentall| 00003500 79 2c 20 6d 65 61 6e 73 20 74 68 65 0a 6c 6f 77 |y, means the.low| 00003510 65 73 74 2d 6e 75 6d 62 65 72 65 64 20 66 69 65 |est-numbered fie| 00003520 6c 64 20 77 68 69 63 68 20 6d 61 79 20 6e 6f 74 |ld which may not| 00003530 20 6e 65 63 65 73 73 61 72 69 6c 79 20 4c 4f 4f | necessarily LOO| 00003540 4b 20 6c 69 6b 65 20 74 68 65 20 66 69 72 73 74 |K like the first| 00003550 20 69 66 20 74 68 65 0a 66 69 65 6c 64 73 20 68 | if the.fields h| 00003560 61 76 65 20 62 65 65 6e 20 70 6c 61 63 65 64 20 |ave been placed | 00003570 69 6e 20 73 74 72 61 6e 67 65 20 70 6f 73 69 74 |in strange posit| 00003580 69 6f 6e 73 20 69 6e 20 74 68 65 20 77 69 6e 64 |ions in the wind| 00003590 6f 77 2e 29 0a 0a 49 66 20 79 6f 75 20 61 72 65 |ow.)..If you are| 000035a0 20 67 6f 69 6e 67 20 74 68 72 6f 75 67 68 20 74 | going through t| 000035b0 68 65 20 64 61 74 61 62 61 73 65 20 6d 61 6b 69 |he database maki| 000035c0 6e 67 20 63 68 61 6e 67 65 73 20 74 6f 20 6f 6e |ng changes to on| 000035d0 65 20 6f 72 20 74 77 6f 20 66 69 65 6c 64 73 0a |e or two fields.| 000035e0 73 6f 6d 65 77 68 65 72 65 20 69 6e 20 74 68 65 |somewhere in the| 000035f0 20 6d 69 64 64 6c 65 20 6f 66 20 74 68 65 20 72 | middle of the r| 00003600 65 63 6f 72 64 20 69 74 20 6d 61 79 20 62 65 20 |ecord it may be | 00003610 63 6f 6e 76 65 6e 69 65 6e 74 20 74 6f 20 68 61 |convenient to ha| 00003620 76 65 20 74 68 65 20 63 61 72 65 74 0a 73 74 61 |ve the caret.sta| 00003630 72 74 20 73 6f 6d 65 77 68 65 72 65 20 65 6c 73 |rt somewhere els| 00003640 65 2e 20 43 6c 69 63 6b 20 4d 45 4e 55 20 6f 76 |e. Click MENU ov| 00003650 65 72 20 74 68 65 20 66 69 65 6c 64 20 77 68 65 |er the field whe| 00003660 72 65 20 79 6f 75 20 77 69 73 68 20 74 68 65 20 |re you wish the | 00003670 63 61 72 65 74 20 74 6f 0a 73 74 61 72 74 2c 20 |caret to.start, | 00003680 67 6f 20 74 6f 20 74 68 65 20 27 46 69 65 6c 64 |go to the 'Field| 00003690 27 20 73 75 62 2d 6d 65 6e 75 20 61 6e 64 20 63 |' sub-menu and c| 000036a0 68 6f 6f 73 65 20 27 53 74 61 72 74 20 65 64 69 |hoose 'Start edi| 000036b0 74 69 6e 67 27 2e 20 57 68 65 6e 65 76 65 72 20 |ting'. Whenever | 000036c0 61 0a 72 65 63 6f 72 64 20 69 73 20 64 69 73 70 |a.record is disp| 000036d0 6c 61 79 65 64 20 74 68 65 20 63 61 72 65 74 20 |layed the caret | 000036e0 77 69 6c 6c 20 6e 6f 77 20 62 65 20 70 6c 61 63 |will now be plac| 000036f0 65 64 20 69 6e 20 74 68 65 20 63 68 6f 73 65 6e |ed in the chosen| 00003700 20 66 69 65 6c 64 2e 20 54 68 65 0a 73 61 6d 65 | field. The.same| 00003710 20 70 72 6f 63 65 64 75 72 65 20 69 73 20 75 73 | procedure is us| 00003720 65 64 20 74 6f 20 72 65 73 74 6f 72 65 20 74 68 |ed to restore th| 00003730 65 20 6e 6f 72 6d 61 6c 20 73 74 61 72 74 69 6e |e normal startin| 00003740 67 20 70 6f 73 69 74 69 6f 6e 2e 20 0a 0a 41 6c |g position. ..Al| 00003750 74 65 72 69 6e 67 20 65 78 69 73 74 69 6e 67 20 |tering existing | 00003760 72 65 63 6f 72 64 73 0a 2d 2d 2d 2d 2d 2d 2d 2d |records.--------| 00003770 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------| 00003780 2d 0a 41 20 64 69 73 70 6c 61 79 65 64 20 72 65 |-.A displayed re| 00003790 63 6f 72 64 20 6d 61 79 20 62 65 20 61 6c 74 65 |cord may be alte| 000037a0 72 65 64 20 6d 61 6e 75 61 6c 6c 79 20 77 69 74 |red manually wit| 000037b0 68 6f 75 74 20 61 6e 79 20 72 65 73 74 72 69 63 |hout any restric| 000037c0 74 69 6f 6e 73 20 6f 74 68 65 72 0a 74 68 61 6e |tions other.than| 000037d0 20 74 68 6f 73 65 20 61 70 70 6c 79 69 6e 67 20 | those applying | 000037e0 74 6f 20 74 68 65 20 61 64 64 69 74 69 6f 6e 20 |to the addition | 000037f0 6f 66 20 6e 65 77 20 72 65 63 6f 72 64 73 20 28 |of new records (| 00003800 73 65 65 20 61 62 6f 76 65 29 2e 20 59 6f 75 20 |see above). You | 00003810 77 69 6c 6c 20 62 65 0a 61 73 6b 65 64 20 74 6f |will be.asked to| 00003820 20 63 6f 6e 66 69 72 6d 20 61 6e 20 61 6c 74 65 | confirm an alte| 00003830 72 61 74 69 6f 6e 20 77 68 69 63 68 20 77 6f 75 |ration which wou| 00003840 6c 64 20 72 65 73 75 6c 74 20 69 6e 20 61 20 63 |ld result in a c| 00003850 68 61 6e 67 65 20 74 6f 20 74 68 65 20 70 72 69 |hange to the pri| 00003860 6d 61 72 79 0a 6b 65 79 2e 20 54 68 65 20 6e 6f |mary.key. The no| 00003870 72 6d 61 6c 20 52 49 53 43 20 4f 53 20 63 6f 6e |rmal RISC OS con| 00003880 76 65 6e 74 69 6f 6e 73 20 66 6f 72 20 65 64 69 |ventions for edi| 00003890 74 69 6e 67 20 77 72 69 74 61 62 6c 65 20 69 63 |ting writable ic| 000038a0 6f 6e 73 20 61 70 70 6c 79 2c 20 65 2e 67 2e 0a |ons apply, e.g..| 000038b0 43 54 52 4c 2d 55 20 74 6f 20 63 6c 65 61 72 20 |CTRL-U to clear | 000038c0 74 68 65 20 69 63 6f 6e 2e 20 41 73 20 77 69 74 |the icon. As wit| 000038d0 68 20 6e 65 77 20 72 65 63 6f 72 64 20 65 6e 74 |h new record ent| 000038e0 72 79 20 79 6f 75 20 6e 65 65 64 20 64 6f 20 6e |ry you need do n| 000038f0 6f 74 68 69 6e 67 20 74 6f 0a 6d 61 6b 65 20 50 |othing to.make P| 00003900 6f 77 65 72 62 61 73 65 20 72 65 63 6f 72 64 20 |owerbase record | 00003910 79 6f 75 72 20 63 68 61 6e 67 65 73 20 74 6f 20 |your changes to | 00003920 64 69 73 63 20 2d 20 74 68 65 20 70 72 6f 63 65 |disc - the proce| 00003930 73 73 20 74 61 6b 65 73 20 70 6c 61 63 65 20 77 |ss takes place w| 00003940 68 65 6e 20 61 0a 64 69 66 66 65 72 65 6e 74 20 |hen a.different | 00003950 72 65 63 6f 72 64 20 69 73 20 64 69 73 70 6c 61 |record is displa| 00003960 79 65 64 2c 20 77 68 65 6e 20 61 20 64 61 74 61 |yed, when a data| 00003970 62 61 73 65 20 69 73 20 63 6c 6f 73 65 64 20 6f |base is closed o| 00003980 72 20 77 68 65 6e 20 79 6f 75 20 71 75 69 74 0a |r when you quit.| 00003990 50 6f 77 65 72 62 61 73 65 2e 0a 0a 43 61 6e 20 |Powerbase...Can | 000039a0 49 20 22 75 6e 64 6f 22 20 69 66 20 49 20 6d 61 |I "undo" if I ma| 000039b0 6b 65 20 61 20 6d 69 73 74 61 6b 65 3f 0a 2d 2d |ke a mistake?.--| 000039c0 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------| 000039d0 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a |---------------.| 000039e0 59 65 73 2c 20 70 72 6f 76 69 64 65 64 20 74 68 |Yes, provided th| 000039f0 61 74 20 79 6f 75 20 68 61 76 65 6e 27 74 20 63 |at you haven't c| 00003a00 6c 69 63 6b 65 64 20 6f 6e 20 27 46 6f 72 63 65 |licked on 'Force| 00003a10 20 75 70 64 61 74 65 27 20 28 61 20 74 68 69 6e | update' (a thin| 00003a20 67 20 79 6f 75 20 73 68 6f 75 6c 64 0a 6e 6f 74 |g you should.not| 00003a30 20 6e 6f 72 6d 61 6c 6c 79 20 6e 65 65 64 20 74 | normally need t| 00003a40 6f 20 64 6f 20 61 6e 79 77 61 79 29 20 6f 72 20 |o do anyway) or | 00003a50 64 6f 6e 65 20 61 6e 79 74 68 69 6e 67 20 77 68 |done anything wh| 00003a60 69 63 68 20 63 61 75 73 65 73 20 50 6f 77 65 72 |ich causes Power| 00003a70 62 61 73 65 20 74 6f 0a 64 69 73 70 6c 61 79 20 |base to.display | 00003a80 61 20 64 69 66 66 65 72 65 6e 74 20 72 65 63 6f |a different reco| 00003a90 72 64 2e 20 49 6e 20 6f 74 68 65 72 20 77 6f 72 |rd. In other wor| 00003aa0 64 73 20 79 6f 75 20 63 61 6e 20 75 6e 64 6f 20 |ds you can undo | 00003ab0 63 68 61 6e 67 65 73 20 6d 61 64 65 20 74 6f 20 |changes made to | 00003ac0 74 68 65 0a 63 75 72 72 65 6e 74 20 72 65 63 6f |the.current reco| 00003ad0 72 64 20 61 73 20 6c 6f 6e 67 20 61 73 20 69 74 |rd as long as it| 00003ae0 20 72 65 6d 61 69 6e 73 20 6f 6e 20 74 68 65 20 | remains on the | 00003af0 73 63 72 65 65 6e 2e 0a 0a 42 72 69 6e 67 20 75 |screen...Bring u| 00003b00 70 20 74 68 65 20 6d 61 69 6e 20 6d 65 6e 75 20 |p the main menu | 00003b10 61 6e 64 20 63 68 6f 6f 73 65 20 27 52 65 73 74 |and choose 'Rest| 00003b20 6f 72 65 20 72 65 63 6f 72 64 27 2e 20 54 68 65 |ore record'. The| 00003b30 20 64 69 73 70 6c 61 79 65 64 20 72 65 63 6f 72 | displayed recor| 00003b40 64 0a 77 69 6c 6c 20 62 65 20 72 65 74 75 72 6e |d.will be return| 00003b50 65 64 20 74 6f 20 74 68 65 20 73 74 61 74 65 20 |ed to the state | 00003b60 69 74 20 77 61 73 20 69 6e 20 77 68 65 6e 20 79 |it was in when y| 00003b70 6f 75 20 64 69 73 70 6c 61 79 65 64 20 69 74 20 |ou displayed it | 00003b80 61 6e 64 20 62 65 66 6f 72 65 20 79 6f 75 0a 62 |and before you.b| 00003b90 65 67 61 6e 20 74 6f 20 65 64 69 74 20 69 74 2e |egan to edit it.| 00003ba0 20 54 6f 20 72 65 73 74 6f 72 65 20 73 69 6e 67 | To restore sing| 00003bb0 6c 65 20 66 69 65 6c 64 73 2c 20 63 6c 69 63 6b |le fields, click| 00003bc0 20 4d 45 4e 55 20 6f 76 65 72 20 74 68 65 20 72 | MENU over the r| 00003bd0 65 71 75 69 72 65 64 0a 66 69 65 6c 64 2c 20 67 |equired.field, g| 00003be0 6f 20 74 6f 20 74 68 65 20 27 46 69 65 6c 64 27 |o to the 'Field'| 00003bf0 20 73 75 62 2d 6d 65 6e 75 20 61 6e 64 20 63 68 | sub-menu and ch| 00003c00 6f 6f 73 65 20 27 52 65 73 74 6f 72 65 20 66 69 |oose 'Restore fi| 00003c10 65 6c 64 27 2e 20 0a 0a 4e 6f 74 65 20 74 68 61 |eld'. ..Note tha| 00003c20 74 20 6f 6e 6c 79 20 6f 72 64 69 6e 61 72 79 20 |t only ordinary | 00003c30 77 72 69 74 61 62 6c 65 20 66 69 65 6c 64 73 20 |writable fields | 00003c40 61 6e 64 20 63 68 65 63 6b 20 62 6f 78 65 73 20 |and check boxes | 00003c50 6d 61 79 20 62 65 20 72 65 73 74 6f 72 65 64 3b |may be restored;| 00003c60 20 79 6f 75 0a 63 61 6e 27 74 20 72 65 73 74 6f | you.can't resto| 00003c70 72 65 20 65 78 74 65 72 6e 61 6c 20 66 69 65 6c |re external fiel| 00003c80 64 73 20 28 73 65 65 20 62 65 6c 6f 77 29 20 77 |ds (see below) w| 00003c90 68 69 63 68 20 69 73 20 77 68 79 20 61 20 77 61 |hich is why a wa| 00003ca0 72 6e 69 6e 67 20 69 73 20 6e 6f 72 6d 61 6c 6c |rning is normall| 00003cb0 79 0a 69 73 73 75 65 64 20 62 65 66 6f 72 65 20 |y.issued before | 00003cc0 64 65 6c 65 74 69 6e 67 20 73 75 63 68 20 66 69 |deleting such fi| 00003cd0 65 6c 64 73 2e 0a 0a 4d 61 6b 69 6e 67 20 74 68 |elds...Making th| 00003ce0 65 20 73 61 6d 65 20 63 68 61 6e 67 65 20 74 6f |e same change to| 00003cf0 20 6d 61 6e 79 20 72 65 63 6f 72 64 73 0a 2d 2d | many records.--| 00003d00 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------| * 00003d20 2d 2d 2d 2d 0a 54 6f 20 61 6c 74 65 72 20 61 20 |----.To alter a | 00003d30 67 69 76 65 6e 20 66 69 65 6c 64 20 69 6e 20 61 |given field in a| 00003d40 20 73 65 74 20 6f 66 20 72 65 63 6f 72 64 73 20 | set of records | 00003d50 79 6f 75 20 6d 75 73 74 20 66 69 72 73 74 20 70 |you must first p| 00003d60 6f 69 6e 74 20 74 68 65 20 6d 6f 75 73 65 20 61 |oint the mouse a| 00003d70 74 0a 74 68 65 20 66 69 65 6c 64 20 61 6e 64 20 |t.the field and | 00003d80 63 6c 69 63 6b 20 4d 45 4e 55 2e 20 54 68 69 73 |click MENU. This| 00003d90 20 67 69 76 65 73 20 61 63 63 65 73 73 20 74 6f | gives access to| 00003da0 20 74 68 65 20 27 46 69 65 6c 64 27 20 73 75 62 | the 'Field' sub| 00003db0 6d 65 6e 75 20 6f 6e 20 77 68 69 63 68 0a 74 68 |menu on which.th| 00003dc0 65 20 73 65 63 6f 6e 64 20 69 74 65 6d 20 69 73 |e second item is| 00003dd0 20 27 47 6c 6f 62 61 6c 20 63 68 61 6e 67 65 73 | 'Global changes| 00003de0 27 2e 20 49 6e 20 74 68 65 20 66 69 72 73 74 20 |'. In the first | 00003df0 77 72 69 74 61 62 6c 65 20 69 63 6f 6e 20 65 6e |writable icon en| 00003e00 74 65 72 0a 77 68 61 74 65 76 65 72 20 79 6f 75 |ter.whatever you| 00003e10 20 77 61 6e 74 20 74 68 65 20 66 69 65 6c 64 20 | want the field | 00003e20 63 68 61 6e 67 69 6e 67 20 74 6f 2e 20 49 6e 20 |changing to. In | 00003e30 74 68 65 20 73 65 63 6f 6e 64 20 65 6e 74 65 72 |the second enter| 00003e40 20 61 20 53 65 61 72 63 68 0a 46 6f 72 6d 75 6c | a Search.Formul| 00003e50 61 20 73 70 65 63 69 66 79 69 6e 67 20 77 68 69 |a specifying whi| 00003e60 63 68 20 72 65 63 6f 72 64 73 20 61 72 65 20 74 |ch records are t| 00003e70 6f 20 62 65 20 63 68 61 6e 67 65 64 2e 20 28 53 |o be changed. (S| 00003e80 65 65 20 27 50 72 69 6e 74 69 6e 67 27 20 61 6e |ee 'Printing' an| 00003e90 64 20 61 6c 73 6f 0a 22 53 65 61 72 63 68 69 6e |d also."Searchin| 00003ea0 67 20 62 79 20 66 69 6c 74 65 72 22 2c 20 61 62 |g by filter", ab| 00003eb0 6f 76 65 2e 29 20 57 68 65 6e 20 79 6f 75 20 63 |ove.) When you c| 00003ec0 6c 69 63 6b 20 6f 6e 20 27 4f 4b 27 20 6f 72 20 |lick on 'OK' or | 00003ed0 74 79 70 65 20 52 45 54 55 52 4e 20 61 6c 6c 0a |type RETURN all.| 00003ee0 6d 61 74 63 68 69 6e 67 20 72 65 63 6f 72 64 73 |matching records| 00003ef0 20 69 6e 20 74 68 65 20 63 75 72 72 65 6e 74 20 | in the current | 00003f00 73 75 62 66 69 6c 65 20 77 69 6c 6c 20 62 65 20 |subfile will be | 00003f10 61 6c 74 65 72 65 64 20 69 6e 20 74 68 65 20 77 |altered in the w| 00003f20 61 79 20 79 6f 75 20 68 61 76 65 0a 73 70 65 63 |ay you have.spec| 00003f30 69 66 69 65 64 2c 20 70 72 6f 76 69 64 65 64 20 |ified, provided | 00003f40 74 68 61 74 20 74 68 65 20 6e 65 77 20 64 61 74 |that the new dat| 00003f50 61 20 77 69 6c 6c 20 66 69 74 2e 20 49 66 20 6e |a will fit. If n| 00003f60 6f 20 73 65 61 72 63 68 20 66 6f 72 6d 75 6c 61 |o search formula| 00003f70 20 69 73 0a 65 6e 74 65 72 65 64 20 74 68 65 6e | is.entered then| 00003f80 20 41 4c 4c 20 72 65 63 6f 72 64 73 20 69 6e 20 | ALL records in | 00003f90 74 68 65 20 73 75 62 66 69 6c 65 20 77 69 6c 6c |the subfile will| 00003fa0 20 62 65 20 63 68 61 6e 67 65 64 2e 20 49 66 20 | be changed. If | 00003fb0 6e 6f 20 6e 65 77 20 64 61 74 61 20 69 73 0a 74 |no new data is.t| 00003fc0 79 70 65 64 20 69 6e 74 6f 20 74 68 65 20 66 69 |yped into the fi| 00003fd0 72 73 74 20 77 72 69 74 61 62 6c 65 20 69 63 6f |rst writable ico| 00003fe0 6e 20 74 68 65 6e 20 74 68 65 20 66 69 65 6c 64 |n then the field| 00003ff0 20 69 6e 20 74 68 65 20 6d 61 74 63 68 69 6e 67 | in the matching| 00004000 20 72 65 63 6f 72 64 73 0a 77 69 6c 6c 20 62 65 | records.will be| 00004010 20 42 4c 41 4e 4b 45 44 2e 0a 0a 59 6f 75 20 6d | BLANKED...You m| 00004020 61 79 20 61 6c 73 6f 20 75 73 65 20 27 47 6c 6f |ay also use 'Glo| 00004030 62 61 6c 20 63 68 61 6e 67 65 73 27 20 74 6f 20 |bal changes' to | 00004040 70 65 72 66 6f 72 6d 20 61 20 73 69 6d 70 6c 65 |perform a simple| 00004050 20 63 61 6c 63 75 6c 61 74 69 6f 6e 20 65 2e 67 | calculation e.g| 00004060 2e 20 22 2b 31 32 22 20 77 69 6c 6c 20 63 61 75 |. "+12" will cau| 00004070 73 65 20 31 32 20 74 6f 20 62 65 20 61 64 64 65 |se 12 to be adde| 00004080 64 20 74 6f 20 74 68 65 20 63 75 72 72 65 6e 74 |d to the current| 00004090 20 76 61 6c 75 65 20 69 6e 20 74 68 65 20 66 69 | value in the fi| 000040a0 65 6c 64 20 6f 6e 0a 61 6c 6c 20 74 68 65 20 6d |eld on.all the m| 000040b0 61 74 63 68 69 6e 67 20 72 65 63 6f 72 64 73 2e |atching records.| 000040c0 20 22 2a 35 2d 31 33 22 20 77 69 6c 6c 20 63 61 | "*5-13" will ca| 000040d0 75 73 65 20 63 75 72 72 65 6e 74 20 74 68 65 20 |use current the | 000040e0 76 61 6c 75 65 20 74 6f 20 62 65 0a 6d 75 6c 74 |value to be.mult| 000040f0 69 70 6c 69 65 64 20 62 79 20 35 20 61 6e 64 20 |iplied by 5 and | 00004100 74 68 65 6e 20 64 65 63 72 65 61 73 65 64 20 62 |then decreased b| 00004110 79 20 31 33 2e 20 49 74 20 69 73 20 6f 70 65 72 |y 13. It is oper| 00004120 61 74 69 6f 6e 73 20 6c 69 6b 65 20 74 68 65 73 |ations like thes| 00004130 65 20 77 68 69 63 68 0a 61 72 65 20 6d 6f 73 74 |e which.are most| 00004140 20 6c 69 6b 65 6c 79 20 74 6f 20 70 72 6f 64 75 | likely to produ| 00004150 63 65 20 76 61 6c 75 65 73 20 77 68 69 63 68 20 |ce values which | 00004160 77 6f 6e 27 74 20 66 69 74 20 69 6e 20 74 68 65 |won't fit in the| 00004170 20 66 69 65 6c 64 2c 20 65 73 70 65 63 69 61 6c | field, especial| 00004180 6c 79 0a 69 66 20 66 6c 6f 61 74 69 6e 67 2d 70 |ly.if floating-p| 00004190 6f 69 6e 74 20 6e 75 6d 62 65 72 73 20 61 72 65 |oint numbers are| 000041a0 20 69 6e 76 6f 6c 76 65 64 2e 20 54 68 65 20 6f | involved. The o| 000041b0 70 65 72 61 74 69 6f 6e 20 69 73 6e 27 74 20 6c |peration isn't l| 000041c0 69 6d 69 74 65 64 20 74 6f 20 4e 75 6d 65 72 69 |imited to Numeri| 000041d0 63 20 66 69 65 6c 64 73 2c 20 6f 72 20 65 76 65 |c fields, or eve| 000041e0 6e 20 74 6f 20 6f 74 68 65 72 20 74 79 70 65 73 |n to other types| 000041f0 20 6f 66 20 66 69 65 6c 64 20 63 6f 6e 73 69 73 | of field consis| 00004200 74 69 6e 67 20 77 68 6f 6c 6c 79 20 6f 66 20 6e |ting wholly of n| 00004210 75 6d 65 72 61 6c 73 3a 20 27 50 6f 77 65 72 62 |umerals: 'Powerb| 00004220 61 73 65 27 20 77 69 6c 6c 20 66 69 6e 64 20 74 |ase' will find t| 00004230 68 65 20 6e 75 6d 62 65 72 20 65 6d 62 65 64 64 |he number embedd| 00004240 65 64 20 69 6e 20 61 6e 20 65 6e 74 72 79 20 73 |ed in an entry s| 00004250 75 63 68 20 61 73 20 22 41 42 43 34 35 58 59 5a |uch as "ABC45XYZ| 00004260 22 20 61 6e 64 20 74 68 65 20 6f 70 65 72 61 74 |" and the operat| 00004270 69 6f 6e 20 22 2b 31 32 22 20 77 6f 75 6c 64 20 |ion "+12" would | 00004280 63 6f 6e 76 65 72 74 20 69 74 20 74 6f 20 22 41 |convert it to "A| 00004290 42 58 35 37 58 59 5a 22 2e 0a 0a 44 65 6c 65 74 |BX57XYZ"...Delet| 000042a0 69 6e 67 20 72 65 63 6f 72 64 73 0a 2d 2d 2d 2d |ing records.----| 000042b0 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a 4f 6e 6c |------------.Onl| 000042c0 79 20 74 68 72 65 65 20 6b 65 79 70 61 64 20 62 |y three keypad b| 000042d0 75 74 74 6f 6e 73 20 73 74 69 6c 6c 20 6e 65 65 |uttons still nee| 000042e0 64 20 65 78 70 6c 61 69 6e 69 6e 67 3b 20 74 68 |d explaining; th| 000042f0 65 20 6c 61 72 67 65 20 6f 6e 65 20 62 65 61 72 |e large one bear| 00004300 69 6e 67 20 74 68 65 0a 64 75 73 74 62 69 6e 20 |ing the.dustbin | 00004310 69 63 6f 6e 20 61 6e 64 20 74 68 65 20 6f 6e 65 |icon and the one| 00004320 73 20 6f 6e 20 65 69 74 68 65 72 20 73 69 64 65 |s on either side| 00004330 20 6f 66 20 69 74 3a 0a 0a 20 20 20 20 20 20 20 | of it:.. | 00004340 20 31 29 20 53 68 69 66 74 20 72 65 63 6f 72 64 | 1) Shift record| 00004350 20 62 61 63 6b 20 28 53 48 2f 66 36 29 20 20 20 | back (SH/f6) | 00004360 20 4d 6f 76 65 73 20 72 65 63 6f 72 64 20 69 6e | Moves record in| 00004370 74 6f 20 70 72 65 76 69 6f 75 73 20 73 75 62 66 |to previous subf| 00004380 69 6c 65 2e 0a 20 20 20 20 20 20 20 20 32 29 20 |ile.. 2) | 00004390 44 65 6c 65 74 65 20 72 65 63 6f 72 64 20 28 43 |Delete record (C| 000043a0 54 2f 66 36 29 20 20 20 20 20 20 20 20 52 65 6d |T/f6) Rem| 000043b0 6f 76 65 73 20 72 65 63 6f 72 64 20 70 65 72 6d |oves record perm| 000043c0 61 6d 65 6e 74 6c 79 2e 0a 20 20 20 20 20 20 20 |amently.. | 000043d0 20 33 29 20 53 68 69 66 74 20 72 65 63 6f 72 64 | 3) Shift record| 000043e0 20 66 6f 72 77 61 72 64 20 28 66 36 29 20 20 20 | forward (f6) | 000043f0 20 4d 6f 76 65 73 20 72 65 63 6f 72 64 20 74 6f | Moves record to| 00004400 20 6e 65 78 74 20 73 75 62 66 69 6c 65 2e 0a 0a | next subfile...| 00004410 54 68 65 20 61 63 74 69 6f 6e 20 6f 66 20 32 29 |The action of 2)| 00004420 20 69 73 20 6f 62 76 69 6f 75 73 6c 79 20 6d 6f | is obviously mo| 00004430 72 65 20 64 72 61 73 74 69 63 20 74 68 61 6e 20 |re drastic than | 00004440 74 68 6f 73 65 20 6f 66 20 74 68 65 20 6f 74 68 |those of the oth| 00004450 65 72 73 20 61 6e 64 20 79 6f 75 0a 77 69 6c 6c |ers and you.will| 00004460 20 62 65 20 61 73 6b 65 64 20 74 6f 20 63 6f 6e | be asked to con| 00004470 66 69 72 6d 20 79 6f 75 72 20 63 68 6f 69 63 65 |firm your choice| 00004480 20 62 65 66 6f 72 65 20 74 68 65 20 72 65 63 6f | before the reco| 00004490 72 64 20 69 73 20 61 63 74 75 61 6c 6c 79 20 64 |rd is actually d| 000044a0 65 6c 65 74 65 64 2e 0a 54 68 65 20 6f 74 68 65 |eleted..The othe| 000044b0 72 73 20 22 64 65 6c 65 74 65 22 20 72 65 63 6f |rs "delete" reco| 000044c0 72 64 73 20 66 72 6f 6d 20 74 68 65 20 63 75 72 |rds from the cur| 000044d0 72 65 6e 74 20 73 75 62 66 69 6c 65 20 62 75 74 |rent subfile but| 000044e0 20 64 6f 20 73 6f 20 77 69 74 68 6f 75 74 20 61 | do so without a| 000044f0 6e 79 0a 66 75 73 73 20 6f 72 20 62 6f 74 68 65 |ny.fuss or bothe| 00004500 72 20 62 65 63 61 75 73 65 20 79 6f 75 20 63 61 |r because you ca| 00004510 6e 20 61 6c 77 61 79 73 20 67 65 74 20 74 68 65 |n always get the| 00004520 6d 20 62 61 63 6b 20 61 67 61 69 6e 2e 20 49 74 |m back again. It| 00004530 20 69 73 20 73 6f 6d 65 74 69 6d 65 73 0a 75 73 | is sometimes.us| 00004540 65 66 75 6c 2c 20 65 73 70 65 63 69 61 6c 6c 79 |eful, especially| 00004550 20 77 68 65 6e 20 72 65 69 6e 73 74 61 74 69 6e | when reinstatin| 00004560 67 20 61 20 72 65 63 6f 72 64 2c 20 74 6f 20 62 |g a record, to b| 00004570 65 20 61 62 6c 65 20 74 6f 20 22 66 6f 6c 6c 6f |e able to "follo| 00004580 77 22 20 69 74 20 69 6e 74 6f 0a 69 74 73 20 6e |w" it into.its n| 00004590 65 77 20 73 75 62 66 69 6c 65 2e 20 59 6f 75 20 |ew subfile. You | 000045a0 63 61 6e 20 64 6f 20 73 6f 20 62 79 20 68 6f 6c |can do so by hol| 000045b0 64 69 6e 67 20 64 6f 77 6e 20 41 4c 54 20 77 68 |ding down ALT wh| 000045c0 69 6c 65 20 79 6f 75 20 63 6c 69 63 6b 20 6f 6e |ile you click on| 000045d0 20 74 68 65 0a 6b 65 79 70 61 64 20 62 75 74 74 | the.keypad butt| 000045e0 6f 6e 2e 0a 0a 44 65 6c 65 74 69 6e 67 20 6d 61 |on...Deleting ma| 000045f0 6e 79 20 72 65 63 6f 72 64 73 20 61 74 20 6f 6e |ny records at on| 00004600 63 65 0a 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |ce.-------------| 00004610 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------| 00004620 0a 50 6f 77 65 72 62 61 73 65 20 70 72 6f 76 69 |.Powerbase provi| 00004630 64 65 73 20 61 20 27 42 61 74 63 68 20 64 65 6c |des a 'Batch del| 00004640 65 74 65 27 20 63 68 6f 69 63 65 20 6f 6e 20 74 |ete' choice on t| 00004650 68 65 20 27 4d 69 73 63 65 6c 6c 61 6e 65 6f 75 |he 'Miscellaneou| 00004660 73 27 20 73 75 62 6d 65 6e 75 2e 0a 49 74 20 6c |s' submenu..It l| 00004670 65 61 64 73 20 74 6f 20 61 20 64 69 61 6c 6f 67 |eads to a dialog| 00004680 75 65 20 62 6f 78 20 77 68 69 63 68 20 64 69 73 |ue box which dis| 00004690 70 6c 61 79 73 20 74 68 65 20 73 61 6d 65 20 74 |plays the same t| 000046a0 68 72 65 65 20 69 63 6f 6e 73 20 61 73 20 74 68 |hree icons as th| 000046b0 6f 73 65 20 6f 6e 0a 74 68 65 20 74 68 72 65 65 |ose on.the three| 000046c0 20 6b 65 79 70 61 64 20 62 75 74 74 6f 6e 73 20 | keypad buttons | 000046d0 6a 75 73 74 20 64 65 73 63 72 69 62 65 64 2e 20 |just described. | 000046e0 48 65 72 65 2c 20 68 6f 77 65 76 65 72 2c 20 74 |Here, however, t| 000046f0 68 65 79 20 61 72 65 20 6d 65 72 65 6c 79 20 66 |hey are merely f| 00004700 6f 72 0a 69 64 65 6e 74 69 66 69 63 61 74 69 6f |or.identificatio| 00004710 6e 2e 20 54 68 65 20 72 61 64 69 6f 20 62 75 74 |n. The radio but| 00004720 74 6f 6e 73 20 62 65 6e 65 61 74 68 20 74 68 65 |tons beneath the| 00004730 6d 20 64 65 74 65 72 6d 69 6e 65 20 77 68 61 74 |m determine what| 00004740 20 77 69 6c 6c 20 68 61 70 70 65 6e 20 74 6f 0a | will happen to.| 00004750 74 68 65 20 72 65 63 6f 72 64 73 20 61 6e 64 20 |the records and | 00004760 74 68 65 20 64 65 66 61 75 6c 74 20 73 65 74 74 |the default sett| 00004770 69 6e 67 20 69 73 20 66 6f 72 20 22 53 68 69 66 |ing is for "Shif| 00004780 74 20 66 6f 72 77 61 72 64 22 2e 20 54 79 70 65 |t forward". Type| 00004790 20 61 20 53 65 61 72 63 68 0a 46 6f 72 6d 75 6c | a Search.Formul| 000047a0 61 20 28 73 65 65 20 27 50 72 69 6e 74 69 6e 67 |a (see 'Printing| 000047b0 27 20 61 6e 64 20 61 6c 73 6f 20 22 53 65 61 72 |' and also "Sear| 000047c0 63 68 69 6e 67 20 62 79 20 66 69 6c 74 65 72 22 |ching by filter"| 000047d0 2c 20 61 62 6f 76 65 29 20 61 6e 64 20 63 6c 69 |, above) and cli| 000047e0 63 6b 0a 27 4f 4b 27 20 6f 72 20 74 79 70 65 20 |ck.'OK' or type | 000047f0 52 45 54 55 52 4e 2e 20 41 6c 6c 20 6d 61 74 63 |RETURN. All matc| 00004800 68 69 6e 67 20 72 65 63 6f 72 64 73 20 69 6e 20 |hing records in | 00004810 74 68 65 20 63 75 72 72 65 6e 74 20 73 75 62 66 |the current subf| 00004820 69 6c 65 20 77 69 6c 6c 20 62 65 0a 6d 6f 76 65 |ile will be.move| 00004830 64 20 6f 72 20 64 65 6c 65 74 65 64 20 61 73 20 |d or deleted as | 00004840 73 70 65 63 69 66 69 65 64 2e 0a 0a 45 78 74 65 |specified...Exte| 00004850 72 6e 61 6c 20 66 69 65 6c 64 73 0a 3d 3d 3d 3d |rnal fields.====| 00004860 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a 45 78 74 65 |===========.Exte| 00004870 72 6e 61 6c 20 66 69 65 6c 64 73 20 61 72 65 20 |rnal fields are | 00004880 64 65 73 63 72 69 62 65 64 20 69 6e 20 73 6f 6d |described in som| 00004890 65 20 64 65 74 61 69 6c 20 69 6e 20 63 6f 6e 6e |e detail in conn| 000048a0 65 63 74 69 6f 6e 20 77 69 74 68 20 63 72 65 61 |ection with crea| 000048b0 74 69 6e 67 20 61 0a 6e 65 77 20 64 61 74 61 62 |ting a.new datab| 000048c0 61 73 65 20 28 73 65 65 20 27 43 72 65 61 74 65 |ase (see 'Create| 000048d0 27 29 2e 20 54 68 65 79 20 69 6e 76 6f 6c 76 65 |'). They involve| 000048e0 20 54 65 78 74 2c 20 53 70 72 69 74 65 20 6f 72 | Text, Sprite or| 000048f0 20 44 72 61 77 20 66 69 6c 65 73 20 28 6f 6e 65 | Draw files (one| 00004900 0a 66 69 6c 65 20 66 6f 72 20 65 61 63 68 20 72 |.file for each r| 00004910 65 63 6f 72 64 29 20 77 68 69 63 68 20 61 72 65 |ecord) which are| 00004920 20 73 74 6f 72 65 64 20 77 69 74 68 69 6e 20 74 | stored within t| 00004930 68 65 20 64 61 74 61 62 61 73 65 20 61 70 70 6c |he database appl| 00004940 69 63 61 74 69 6f 6e 0a 64 69 72 65 63 74 6f 72 |ication.director| 00004950 79 20 61 6e 64 20 61 72 65 20 65 69 74 68 65 72 |y and are either| 00004960 20 6c 69 6e 6b 65 64 20 74 6f 20 62 75 74 74 6f | linked to butto| 00004970 6e 73 20 6f 6e 20 74 68 65 20 72 65 63 6f 72 64 |ns on the record| 00004980 20 73 63 72 65 65 6e 20 6f 72 20 61 72 65 0a 61 | screen or are.a| 00004990 63 74 75 61 6c 6c 79 20 64 69 73 70 6c 61 79 65 |ctually displaye| 000049a0 64 20 69 6e 20 6c 61 72 67 65 20 69 63 6f 6e 73 |d in large icons| 000049b0 20 6f 6e 20 74 68 65 20 72 65 63 6f 72 64 20 73 | on the record s| 000049c0 63 72 65 65 6e 2e 20 28 54 68 65 20 6c 61 74 74 |creen. (The latt| 000049d0 65 72 20 74 79 70 65 0a 63 61 6e 6e 6f 74 20 62 |er type.cannot b| 000049e0 65 20 75 73 65 64 20 66 6f 72 20 44 72 61 77 20 |e used for Draw | 000049f0 66 69 6c 65 73 2e 29 20 54 68 65 79 20 70 72 6f |files.) They pro| 00004a00 76 69 64 65 20 61 20 6d 65 61 6e 73 20 6f 66 20 |vide a means of | 00004a10 61 73 73 6f 63 69 61 74 69 6e 67 20 72 65 63 6f |associating reco| 00004a20 72 64 0a 66 69 65 6c 64 73 20 77 69 74 68 20 70 |rd.fields with p| 00004a30 69 63 74 75 72 65 73 20 61 6e 64 20 77 69 74 68 |ictures and with| 00004a40 20 62 6c 6f 63 6b 73 20 6f 66 20 74 65 78 74 20 | blocks of text | 00004a50 77 68 69 63 68 20 61 72 65 20 74 6f 6f 20 62 69 |which are too bi| 00004a60 67 20 74 6f 20 66 69 74 20 61 0a 6e 6f 72 6d 61 |g to fit a.norma| 00004a70 6c 20 74 65 78 74 20 66 69 65 6c 64 2e 0a 0a 59 |l text field...Y| 00004a80 6f 75 20 63 61 6e 27 74 20 65 64 69 74 20 61 6e |ou can't edit an| 00004a90 20 45 78 74 65 72 6e 61 6c 20 66 69 65 6c 64 20 | External field | 00004aa0 64 69 72 65 63 74 6c 79 2c 20 65 76 65 6e 20 77 |directly, even w| 00004ab0 68 65 6e 20 69 74 20 63 6f 6e 74 61 69 6e 73 20 |hen it contains | 00004ac0 74 65 78 74 20 61 73 0a 6f 70 70 6f 73 65 64 20 |text as.opposed | 00004ad0 74 6f 20 67 72 61 70 68 69 63 73 2e 20 57 68 65 |to graphics. Whe| 00004ae0 6e 20 79 6f 75 20 6d 6f 76 65 20 74 68 65 20 70 |n you move the p| 00004af0 6f 69 6e 74 65 72 20 6f 76 65 72 20 73 75 63 68 |ointer over such| 00004b00 20 61 20 66 69 65 6c 64 20 69 74 20 63 68 61 6e | a field it chan| 00004b10 67 65 73 0a 74 6f 20 74 77 6f 20 6c 69 6e 6b 65 |ges.to two linke| 00004b20 64 20 73 71 75 61 72 65 73 20 69 6e 64 69 63 61 |d squares indica| 00004b30 74 69 6e 67 20 74 68 61 74 20 74 68 65 20 64 61 |ting that the da| 00004b40 74 61 20 61 73 73 6f 63 69 61 74 65 64 20 77 69 |ta associated wi| 00004b50 74 68 20 74 68 65 20 66 69 65 6c 64 20 69 73 0a |th the field is.| 00004b60 6c 69 6e 6b 65 64 20 74 6f 20 69 74 20 62 75 74 |linked to it but| 00004b70 20 6e 6f 74 20 61 63 74 75 61 6c 6c 79 20 22 69 | not actually "i| 00004b80 6e 22 20 69 74 20 69 6e 20 74 68 65 20 73 65 6e |n" it in the sen| 00004b90 73 65 20 74 68 61 74 20 64 61 74 61 20 69 6e 20 |se that data in | 00004ba0 6f 72 64 69 6e 61 72 79 0a 65 64 69 74 61 62 6c |ordinary.editabl| 00004bb0 65 20 66 69 65 6c 64 73 20 69 73 2e 0a 0a 54 6f |e fields is...To| 00004bc0 20 6c 69 6e 6b 20 61 20 66 69 6c 65 20 77 69 74 | link a file wit| 00004bd0 68 20 73 75 63 68 20 61 20 66 69 65 6c 64 20 61 |h such a field a| 00004be0 6c 6c 20 79 6f 75 20 6e 65 65 64 20 64 6f 20 69 |ll you need do i| 00004bf0 73 20 64 72 61 67 20 74 68 65 20 66 69 6c 65 27 |s drag the file'| 00004c00 73 20 69 63 6f 6e 0a 6f 6e 74 6f 20 74 68 65 20 |s icon.onto the | 00004c10 72 65 63 6f 72 64 20 77 69 6e 64 6f 77 20 61 6e |record window an| 00004c20 64 20 64 72 6f 70 20 69 74 20 6f 6e 20 74 68 65 |d drop it on the| 00004c30 20 61 70 70 72 6f 70 72 69 61 74 65 20 66 69 65 | appropriate fie| 00004c40 6c 64 2e 20 49 66 2c 20 66 6f 72 0a 65 78 61 6d |ld. If, for.exam| 00004c50 70 6c 65 2c 20 74 68 65 20 72 65 63 6f 72 64 20 |ple, the record | 00004c60 69 6e 63 6c 75 64 65 73 20 61 20 66 69 65 6c 64 |includes a field| 00004c70 20 72 65 70 72 65 73 65 6e 74 65 64 20 62 79 20 | represented by | 00004c80 61 20 22 54 65 78 74 22 20 62 75 74 74 6f 6e 2c |a "Text" button,| 00004c90 20 69 2e 65 2e 0a 6f 6e 65 20 62 65 61 72 69 6e | i.e..one bearin| 00004ca0 67 20 61 20 73 6d 61 6c 6c 20 76 65 72 73 69 6f |g a small versio| 00004cb0 6e 20 6f 66 20 74 68 65 20 45 64 69 74 20 69 63 |n of the Edit ic| 00004cc0 6f 6e 2c 20 79 6f 75 20 6d 61 79 20 64 72 6f 70 |on, you may drop| 00004cd0 20 61 20 54 65 78 74 20 66 69 6c 65 20 6f 6e 74 | a Text file ont| 00004ce0 6f 0a 69 74 2e 20 54 68 65 20 62 75 74 74 6f 6e |o.it. The button| 00004cf0 27 73 20 69 63 6f 6e 20 63 68 61 6e 67 65 73 20 |'s icon changes | 00004d00 74 6f 20 74 68 65 20 73 6d 61 6c 6c 20 76 65 72 |to the small ver| 00004d10 73 69 6f 6e 20 6f 66 20 74 68 65 20 54 65 78 74 |sion of the Text| 00004d20 20 66 69 6c 65 20 69 63 6f 6e 20 74 6f 0a 69 6e | file icon to.in| 00004d30 64 69 63 61 74 65 20 74 68 61 74 20 74 68 65 20 |dicate that the | 00004d40 66 69 6c 65 20 68 61 73 20 62 65 65 6e 20 6c 69 |file has been li| 00004d50 6e 6b 65 64 2e 20 41 73 20 6c 6f 6e 67 20 61 73 |nked. As long as| 00004d60 20 74 68 65 20 66 69 6c 65 72 20 68 61 73 20 22 | the filer has "| 00004d70 73 65 65 6e 22 20 74 68 65 0a 45 64 69 74 20 61 |seen" the.Edit a| 00004d80 70 70 6c 69 63 61 74 69 6f 6e 20 28 6f 72 20 73 |pplication (or s| 00004d90 6f 6d 65 20 6f 74 68 65 72 20 52 49 53 43 20 4f |ome other RISC O| 00004da0 53 20 74 65 78 74 20 65 64 69 74 6f 72 29 20 63 |S text editor) c| 00004db0 6c 69 63 6b 69 6e 67 20 6f 6e 20 74 68 65 20 62 |licking on the b| 00004dc0 75 74 74 6f 6e 0a 77 69 74 68 20 53 45 4c 45 43 |utton.with SELEC| 00004dd0 54 20 77 69 6c 6c 20 6c 6f 61 64 20 74 68 65 20 |T will load the | 00004de0 66 69 6c 65 20 69 6e 74 6f 20 74 68 65 20 65 64 |file into the ed| 00004df0 69 74 6f 72 20 61 6e 64 20 64 69 73 70 6c 61 79 |itor and display| 00004e00 20 69 74 2e 20 59 6f 75 20 6d 61 79 20 74 68 65 | it. You may the| 00004e10 6e 0a 65 64 69 74 20 74 68 65 20 66 69 6c 65 20 |n.edit the file | 00004e20 61 6e 64 20 72 65 2d 73 61 76 65 20 69 74 20 77 |and re-save it w| 00004e30 69 74 68 6f 75 74 20 61 6c 74 65 72 69 6e 67 20 |ithout altering | 00004e40 69 74 73 20 6e 61 6d 65 20 61 6e 64 20 69 74 20 |its name and it | 00004e50 77 69 6c 6c 20 73 74 69 6c 6c 20 62 65 0a 61 73 |will still be.as| 00004e60 73 6f 63 69 61 74 65 64 20 77 69 74 68 20 74 68 |sociated with th| 00004e70 65 20 73 61 6d 65 20 66 69 65 6c 64 20 6f 66 20 |e same field of | 00004e80 74 68 65 20 73 61 6d 65 20 72 65 63 6f 72 64 2e |the same record.| 00004e90 20 53 70 72 69 74 65 20 61 6e 64 20 44 72 61 77 | Sprite and Draw| 00004ea0 20 66 69 6c 65 73 20 6d 61 79 0a 62 65 20 64 72 | files may.be dr| 00004eb0 6f 70 70 65 64 20 6f 6e 74 6f 20 74 68 65 20 61 |opped onto the a| 00004ec0 70 70 72 6f 70 72 69 61 74 65 20 74 79 70 65 20 |ppropriate type | 00004ed0 6f 66 20 62 75 74 74 6f 6e 20 69 6e 20 65 78 61 |of button in exa| 00004ee0 63 74 6c 79 20 74 68 65 20 73 61 6d 65 20 77 61 |ctly the same wa| 00004ef0 79 20 61 6e 64 0a 6d 61 79 20 62 65 20 64 69 73 |y and.may be dis| 00004f00 70 6c 61 79 65 64 20 61 6e 64 20 65 64 69 74 65 |played and edite| 00004f10 64 20 77 69 74 68 20 50 61 69 6e 74 20 61 6e 64 |d with Paint and| 00004f20 20 44 72 61 77 20 72 65 73 70 65 63 74 69 76 65 | Draw respective| 00004f30 6c 79 2e 0a 0a 41 20 66 69 65 6c 64 20 6f 66 20 |ly...A field of | 00004f40 27 54 65 78 74 20 42 6c 6f 63 6b 27 20 74 79 70 |'Text Block' typ| 00004f50 65 20 6d 61 79 20 61 6c 73 6f 20 68 61 76 65 20 |e may also have | 00004f60 61 20 54 65 78 74 20 66 69 6c 65 20 64 72 6f 70 |a Text file drop| 00004f70 70 65 64 20 6f 6e 74 6f 20 69 74 2e 20 54 68 69 |ped onto it. Thi| 00004f80 73 0a 74 69 6d 65 20 74 68 65 20 74 65 78 74 20 |s.time the text | 00004f90 28 6f 72 20 61 73 20 6d 75 63 68 20 6f 66 20 69 |(or as much of i| 00004fa0 74 20 61 73 20 77 69 6c 6c 20 66 69 74 20 69 6e |t as will fit in| 00004fb0 73 69 64 65 20 74 68 65 20 69 63 6f 6e 27 73 20 |side the icon's | 00004fc0 62 6f 75 6e 64 69 6e 67 20 62 6f 78 29 0a 69 73 |bounding box).is| 00004fd0 20 61 63 74 75 61 6c 6c 79 20 64 69 73 70 6c 61 | actually displa| 00004fe0 79 65 64 20 6f 6e 20 74 68 65 20 72 65 63 6f 72 |yed on the recor| 00004ff0 64 20 77 69 6e 64 6f 77 2e 20 59 6f 75 20 63 61 |d window. You ca| 00005000 6e 27 74 20 65 64 69 74 20 74 68 65 20 74 65 78 |n't edit the tex| 00005010 74 20 64 69 72 65 63 74 6c 79 0a 28 63 6c 69 63 |t directly.(clic| 00005020 6b 69 6e 67 20 77 69 74 68 20 53 45 4c 45 43 54 |king with SELECT| 00005030 20 6f 76 65 72 20 69 74 20 68 61 73 20 6e 6f 20 | over it has no | 00005040 65 66 66 65 63 74 29 20 62 75 74 20 69 74 20 69 |effect) but it i| 00005050 73 20 70 6f 73 73 69 62 6c 65 20 74 6f 20 65 78 |s possible to ex| 00005060 70 6f 72 74 0a 74 68 65 20 66 69 6c 65 20 66 6f |port.the file fo| 00005070 72 20 65 64 69 74 69 6e 67 20 28 73 65 65 20 62 |r editing (see b| 00005080 65 6c 6f 77 29 2e 20 53 70 72 69 74 65 20 66 69 |elow). Sprite fi| 00005090 6c 65 73 20 6d 61 79 20 62 65 20 64 72 6f 70 70 |les may be dropp| 000050a0 65 64 20 6f 6e 74 6f 20 61 6e 64 0a 64 69 73 70 |ed onto and.disp| 000050b0 6c 61 79 65 64 20 69 6e 20 61 20 66 69 65 6c 64 |layed in a field| 000050c0 20 6f 66 20 27 50 69 63 74 75 72 65 27 20 74 79 | of 'Picture' ty| 000050d0 70 65 2e 0a 0a 41 6e 79 20 6e 65 77 20 66 69 6c |pe...Any new fil| 000050e0 65 20 64 72 6f 70 70 65 64 20 6f 6e 74 6f 20 61 |e dropped onto a| 000050f0 6e 20 65 78 74 65 72 6e 61 6c 20 66 69 65 6c 64 |n external field| 00005100 20 77 68 69 63 68 20 69 73 20 61 6c 72 65 61 64 | which is alread| 00005110 79 20 6c 69 6e 6b 65 64 20 74 6f 20 61 0a 66 69 |y linked to a.fi| 00005120 6c 65 20 73 69 6d 70 6c 79 20 72 65 70 6c 61 63 |le simply replac| 00005130 65 73 20 74 68 65 20 6f 6c 64 20 66 69 6c 65 20 |es the old file | 00005140 77 69 74 68 20 74 68 65 20 6e 65 77 2e 0a 0a 4e |with the new...N| 00005150 4f 54 45 20 49 66 20 79 6f 75 20 64 72 6f 70 20 |OTE If you drop | 00005160 61 20 74 65 78 74 20 66 69 6c 65 20 69 6e 20 74 |a text file in t| 00005170 68 65 20 77 72 6f 6e 67 20 70 6c 61 63 65 20 69 |he wrong place i| 00005180 6e 20 74 68 65 20 72 65 63 6f 72 64 20 77 69 6e |n the record win| 00005190 64 6f 77 0a 50 6f 77 65 72 62 61 73 65 20 77 69 |dow.Powerbase wi| 000051a0 6c 6c 20 74 68 69 6e 6b 20 79 6f 75 20 77 61 6e |ll think you wan| 000051b0 74 20 74 6f 20 74 72 65 61 74 20 74 68 65 20 66 |t to treat the f| 000051c0 69 6c 65 20 61 73 20 6c 69 6b 65 20 43 53 56 20 |ile as like CSV | 000051d0 66 69 6c 65 20 61 6e 64 20 69 6d 70 6f 72 74 0a |file and import.| 000051e0 64 61 74 61 20 66 72 6f 6d 20 69 74 20 28 73 65 |data from it (se| 000051f0 65 20 27 43 53 56 20 66 69 6c 65 73 27 29 20 61 |e 'CSV files') a| 00005200 6e 64 20 74 68 65 20 27 49 6d 70 6f 72 74 20 74 |nd the 'Import t| 00005210 65 78 74 20 66 69 6c 65 27 20 77 69 6e 64 6f 77 |ext file' window| 00005220 20 77 69 6c 6c 0a 61 70 70 65 61 72 2e 20 54 68 | will.appear. Th| 00005230 69 73 20 69 73 20 73 6f 6d 65 77 68 61 74 20 73 |is is somewhat s| 00005240 74 61 72 74 6c 69 6e 67 20 62 75 74 20 68 61 72 |tartling but har| 00005250 6d 6c 65 73 73 20 65 6e 6f 75 67 68 20 61 73 20 |mless enough as | 00005260 6c 6f 6e 67 20 61 73 20 79 6f 75 20 64 6f 6e 27 |long as you don'| 00005270 74 0a 63 6c 69 63 6b 20 6f 6e 20 27 47 4f 27 20 |t.click on 'GO' | 00005280 6f 72 20 74 79 70 65 20 52 45 54 55 52 4e 21 20 |or type RETURN! | 00005290 43 6c 69 63 6b 20 6f 6e 20 27 43 61 6e 63 65 6c |Click on 'Cancel| 000052a0 27 20 74 6f 20 67 65 74 20 72 69 64 20 6f 66 20 |' to get rid of | 000052b0 74 68 65 20 77 69 6e 64 6f 77 2e 0a 0a 45 64 69 |the window...Edi| 000052c0 74 69 6e 67 20 65 78 74 65 72 6e 61 6c 20 66 69 |ting external fi| 000052d0 65 6c 64 73 0a 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |elds.-----------| 000052e0 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a 43 6c 69 |------------.Cli| 000052f0 63 6b 69 6e 67 20 4d 45 4e 55 20 6f 76 65 72 20 |cking MENU over | 00005300 61 6e 20 65 78 74 65 72 6e 61 6c 20 66 69 65 6c |an external fiel| 00005310 64 20 6d 61 6b 65 73 20 61 76 61 69 6c 61 62 6c |d makes availabl| 00005320 65 20 63 65 72 74 61 69 6e 20 65 6e 74 72 69 65 |e certain entrie| 00005330 73 20 6f 6e 20 74 68 65 0a 27 46 69 65 6c 64 27 |s on the.'Field'| 00005340 20 73 75 62 6d 65 6e 75 20 77 68 69 63 68 20 61 | submenu which a| 00005350 72 65 20 73 68 61 64 65 64 20 66 6f 72 20 6f 74 |re shaded for ot| 00005360 68 65 72 20 74 79 70 65 73 20 6f 66 20 66 69 65 |her types of fie| 00005370 6c 64 2e 20 27 43 6c 65 61 72 20 63 6f 6e 74 65 |ld. 'Clear conte| 00005380 6e 74 73 27 0a 65 6e 61 62 6c 65 73 20 79 6f 75 |nts'.enables you| 00005390 20 74 6f 20 64 65 6c 65 74 65 20 74 68 65 20 6c | to delete the l| 000053a0 69 6e 6b 65 64 20 66 69 6c 65 20 66 72 6f 6d 20 |inked file from | 000053b0 74 68 65 20 64 61 74 61 62 61 73 65 20 61 70 70 |the database app| 000053c0 6c 69 63 61 74 69 6f 6e 2e 20 53 69 6e 63 65 0a |lication. Since.| 000053d0 64 65 6c 65 74 69 6e 67 20 61 20 77 68 6f 6c 65 |deleting a whole| 000053e0 20 66 69 6c 65 20 69 73 20 72 61 74 68 65 72 20 | file is rather | 000053f0 64 72 61 73 74 69 63 20 79 6f 75 20 77 6f 75 6c |drastic you woul| 00005400 64 20 70 72 6f 62 61 62 6c 79 20 6c 69 6b 65 20 |d probably like | 00005410 74 6f 20 62 65 20 77 61 72 6e 65 64 0a 77 68 65 |to be warned.whe| 00005420 6e 20 74 68 69 73 20 69 73 20 61 62 6f 75 74 20 |n this is about | 00005430 74 6f 20 68 61 70 70 65 6e 2e 20 54 68 65 20 6d |to happen. The m| 00005440 65 73 73 61 67 65 20 22 44 65 6c 65 74 65 20 6f |essage "Delete o| 00005450 62 6a 65 63 74 3f 20 41 72 65 20 79 6f 75 20 73 |bject? Are you s| 00005460 75 72 65 3f 22 0a 6e 6f 72 6d 61 6c 6c 79 20 61 |ure?".normally a| 00005470 70 70 65 61 72 73 2c 20 62 75 74 20 79 6f 75 20 |ppears, but you | 00005480 63 61 6e 20 64 69 73 61 62 6c 65 20 69 74 20 62 |can disable it b| 00005490 79 20 63 6c 69 63 6b 69 6e 67 20 27 57 61 72 6e |y clicking 'Warn| 000054a0 20 6f 66 20 64 65 6c 65 74 65 27 20 6f 6e 20 74 | of delete' on t| 000054b0 68 65 0a 27 46 69 65 6c 64 27 20 73 75 62 6d 65 |he.'Field' subme| 000054c0 6e 75 20 73 6f 20 74 68 61 74 20 74 68 65 20 65 |nu so that the e| 000054d0 6e 74 72 79 20 62 65 63 6f 6d 65 73 20 75 6e 74 |ntry becomes unt| 000054e0 69 63 6b 65 64 2e 20 46 69 6e 61 6c 6c 79 2c 20 |icked. Finally, | 000054f0 27 53 61 76 65 20 63 6f 6e 74 65 6e 74 73 27 0a |'Save contents'.| 00005500 6f 6e 20 74 68 65 20 27 46 69 65 6c 64 27 20 73 |on the 'Field' s| 00005510 75 62 6d 65 6e 75 20 70 65 72 6d 69 74 73 20 79 |ubmenu permits y| 00005520 6f 75 20 74 6f 20 65 78 70 6f 72 74 20 74 68 65 |ou to export the| 00005530 20 6c 69 6e 6b 65 64 20 66 69 65 6c 64 20 74 6f | linked field to| 00005540 20 61 20 66 69 6c 65 72 0a 77 69 6e 64 6f 77 20 | a filer.window | 00005550 6f 72 20 64 69 72 65 63 74 6c 79 20 69 6e 74 6f |or directly into| 00005560 20 45 64 69 74 2c 20 50 61 69 6e 74 20 6f 72 20 | Edit, Paint or | 00005570 44 72 61 77 2e 0a 0a 49 6e 20 74 68 65 20 63 61 |Draw...In the ca| 00005580 73 65 20 6f 66 20 27 54 65 78 74 27 20 61 6e 64 |se of 'Text' and| 00005590 20 27 54 65 78 74 20 42 6c 6f 63 6b 27 20 66 69 | 'Text Block' fi| 000055a0 65 6c 64 73 20 61 20 6d 6f 72 65 20 63 6f 6e 76 |elds a more conv| 000055b0 65 6e 69 65 6e 74 20 6d 65 61 6e 73 20 6f 66 0a |enient means of.| 000055c0 65 78 70 6f 72 74 69 6e 67 20 74 68 65 20 66 69 |exporting the fi| 000055d0 6c 65 20 69 73 20 74 6f 20 73 65 6c 65 63 74 20 |le is to select | 000055e0 74 68 65 20 66 69 65 6c 64 20 61 73 20 69 66 20 |the field as if | 000055f0 66 6f 72 20 70 72 69 6e 74 69 6e 67 20 74 68 65 |for printing the| 00005600 6e 20 74 79 70 65 0a 53 48 49 46 54 2f 66 35 2e |n type.SHIFT/f5.| 00005610 20 54 68 65 20 27 53 61 76 65 27 20 62 6f 78 20 | The 'Save' box | 00005620 63 6f 6e 74 61 69 6e 69 6e 67 20 74 68 65 20 64 |containing the d| 00005630 65 66 61 75 6c 74 20 66 69 6c 65 6e 61 6d 65 20 |efault filename | 00005640 77 69 6c 6c 20 74 68 65 6e 20 61 70 70 65 61 72 |will then appear| 00005650 2e 0a 54 68 69 73 20 77 6f 72 6b 73 20 6f 6e 6c |..This works onl| 00005660 79 20 77 68 65 6e 20 6e 6f 74 68 69 6e 67 20 65 |y when nothing e| 00005670 6c 73 65 20 62 75 74 20 74 68 65 20 72 65 71 75 |lse but the requ| 00005680 69 72 65 64 20 66 69 65 6c 64 20 69 73 20 73 65 |ired field is se| 00005690 6c 65 63 74 65 64 2e 20 49 74 0a 63 61 6e 27 74 |lected. It.can't| 000056a0 20 62 65 20 75 73 65 64 20 77 69 74 68 20 27 50 | be used with 'P| 000056b0 69 63 74 75 72 65 27 2c 20 27 53 70 72 69 74 65 |icture', 'Sprite| 000056c0 27 20 6f 72 20 27 44 72 61 77 27 20 66 69 65 6c |' or 'Draw' fiel| 000056d0 64 73 20 62 65 63 61 75 73 65 20 74 68 65 73 65 |ds because these| 000056e0 20 63 61 6e 0a 6e 65 76 65 72 20 66 6f 72 6d 20 | can.never form | 000056f0 70 61 72 74 20 6f 66 20 61 20 70 72 69 6e 74 20 |part of a print | 00005700 73 65 6c 65 63 74 69 6f 6e 20 61 6e 64 20 63 61 |selection and ca| 00005710 6e 6e 6f 74 20 74 68 65 72 65 66 6f 72 65 20 62 |nnot therefore b| 00005720 65 20 73 65 6c 65 63 74 65 64 20 77 69 74 68 0a |e selected with.| 00005730 74 68 65 20 6d 6f 75 73 65 2e 0a |the mouse..| 0000573b