.Mi Amiga File Docs .Courtesy of RIVER ROAD CHAPTER TWO MIAMIGA FILE OPERATING ENVIRONMENT Start MiAmiga File Start MiAmiga File from the Workbench disk by double clicking on its icon. This instructs the system to begin MiAmiga File. When MiAmiga File databases exist, you may also start by double clicking on a database icon. List Window Upon starting, the first screen to apppear is the List Window. It is from this window that you will: create a database, search for desired information, sort, and access the MiAmiga File's Form Window Form Window Once a database has been defined, the Form Window may be accessed. Use this window to enter data into the database. Menu Bar At the top of the screen is a menu bar which will allow access to many of MiAmiga File's features. To view the menu bar and available menu titles, press the button on the right side of the mouse. To view a menu title's items, continue holding the mouse button down and glide it on to the desired menu title. All of the functions belonging to that menu will appear. You can choose the desired function by gliding the mouse down and releasing the mouse when that function is highlighted. As a shortcut some menu items may be selected by pressing the right Amiga key and a letter key simultaneously. The letter seen to the right of these menu items is the letter to be used. For example, Amiga-N will select the New Column item from the Column Menu. Dialog Boxes Occasionally, you will need to supply the computer with a little more information to allow it to complete a specific command. In such cases, you will either be asked to do something or to add additional information. This will be done from a MiAmiga File dialog box. A dialog box requires you to respond to it before you can continue. For example, if you wanted to delete a record in your database, a dialog box will appear on your screen to warn you about what you are about to do, and ask if you are sure you want to do this. A dialog box will also appear to warn you of an error, ask you to change disks or to let you know what the system is doing. Scroll Bars On the right and bottom of the List Window, and the left and right of the Form Window are areas called scroll bars. A scroll bar consists of four parts: 2 arrows, an elevator bar, and an elevator shaft. On a List Window, the right scroll bar allows you to peruse your data base - the bottom scroll bar allows access to columns (fields) not in view. On a Form Window, the right scroll bar peruses through the database, and the left scroll bar accesses areas of the form not in view. Backup Disks Information which you have stored on your disk is extremely valuble to you. Therefore it is very important that you create backup files to ensure against possible loss of data. We recommend that you save your work every fifteen to thirty minutes and that you create a backup disk at least once a day. Once you have made your backup disk, keep the original in a safe place and use the backup for everyday use. Quitting MiAmiga File Do not turn off the computer while still working on your file. In order to quit MiAmiga File, select Save (to save the latest version of your file) and then select Quit from the File Menu. CHAPTER THREE CREATING MIAMIGA FILES Types of Fields In this chapter we will create a sample file for a health club. DURKIN'S HEALTH CLUB needs to keep track of their members name and address, length of enrollment, price they paid per membership and their weight and height when they joined. The first step is to open a new file. This is accomplished in one of two ways; when you first load your MiAmiga File program or by selecting New from the File menu. Now that we have our file, the first stage in building a new database is to choose the types of fields we wish to use. MiAmiga File allows us a choice of eight different types fo fields, which are as follows: ALPHA: This field will accept letters and spaces only. It is used to help reduce the number of input errors. AMOUNT: The amount field will accept numbers and decimal points. This field can also provide dollar signs, commas and up to two decimal positions. DATE: Dates must be entered in this format: MM/DD/YY. TEXT: This field is the most commonly used, because it accepts all letters, numbers and symbols. For example, it could be used with an address field which may contain a number. (i.e. 525 Wentworth) TIME: Time is entered in this format: HH:MM, either AM or PM. You can enter time in military format and it will auto- matically be converted to AM/PM. YES/NO: This field is used for yes/no responses. It is very useful for statistics, surveys, etc. PHONE: This field will accept the characters; (), hyphens and a period. i.e. (805)966-5884. ALPHA/: Uses alphabetic and numeric characters and spaces. NUMERIC In our sample file we need to set up twelve new fields. In MiAmiga File these fields will appear as columns. In order to add new fields we need to select New from the Column menu at the upper portion of our window. By pressing Amiga N you will achieve the same results. Our screen will display a dialog box. On the line titled Column Name, type in the name of the first field. If you make a mistake, the backspace key will delete the previous character. Next, let us select the Alpha field type by clicking on the box next to the word Alpha. Once the column is set up correctly, click on the OK box at the bottom of the dialog box. Once you have added records to your file you will not be able to change the field type. You can however add new fields and or delete an existing field. The second field we need to add to our record is address. This field will incorporate numbers, letters and possibly special symbols. Again, we need to select New from the Column menu. Enter the name, Address, on the line Column Name and select Text as the Column Type. Click OK to add this field. Remember with MiAmiga File you have up to thirty-two fields available. If and when you use all fields, the New Option from the Column menu will be turned off. When you delete a field from your record the option will available once again. At this point let us add the remaining columns or fields to our record. Column Name Column Type City Alpha State Alpha Zip Code Text Amount Paid Amount Date Joined Date # of years Text Height Text Weight Text New Membership Yes/No Phone Phone Scrolling the Input MiAmiga File offers three different ways of scrolling or looking through the work you have entered into your database. You will have noticed, by now, that you cannot view all of the fields you have added to your record at once. The horizontal scroll bar at the bottom of your screen can be used to view the remaining or previous fields in a record. To view your record quickly, place the pointer inside the white box and drag it across your screen. The second and third scroll bars are located at the right and left sides of your window. The one on the right is used to view individual records in your file. The one on the left is used to scroll the form. They are used in the same manner in which the horizontal scroll bar is used. Changing a Field To change a field name, position the pointer in the box at the top row containing that field and click. Highlighting a Field Name If you do not have records on this file, you will be able to change the field name and field type. To make this change go to the Column menu and select Change. The dialog box that appears on your screen is the same as when you initially set up this field. If you have already added records to your file, the only change available is to change the field name. Changing A Field Name Type in the new field name, Names and click on the OK box. Sometimes, however, we need to change the field type even if we have added records to our file. To accomplish this, we need to create a new field with the field type desired, and input the information from the old field to the new field. Upon completion of transfering the information to the new field, delete the old one. Deleting Fields The first question to ask yourself is, "Do I really want to erase the information in this field?". If you have decided yes, the next question is, "Have I copied the information in a backup file in case I need it at a later date?" The reason for these precautions is that once you delete a field or column, you have lost the entire file. Fields can be deleted by clicking on the box at the top of the column. Click on the column titled Weight. When it is highlighted go to the Column menu and select Delete. MiAmiga File will ask you if this is what you really want to do. Select "yes" since this may be a touchy subject with some members. Moving Fields MiAmiga File allows you to rearrange your list of fields even if you have added, changed or deleted records in your file. This is done by placing the pointer in the field name box at the top of your window and holding down on the button. You will notice that the entire column will be outlined in a heavy line. At this time drag the column to the desired position and release the button. Now, let's experimint with the Amount Paid field. Position the pointer in the box at the top of the window, press and drag it in front of the field, # of years. Your entire file has now been rearranged to accommodate this change. Changing the Column Width Occasionally we will need to adjust the width of our fields. For example, our address field needs a little more room to accommodate all of its information and our # of years field is too large. Column width can be lengthened or shortened to display more or less of the field you are working with. To change the width of a column, place the pointer on the dotted line between columns and hold down the button. This will automatically adjust all other fields in your record. Saving Your File Now that we have defined the fields of the records in our new database file, it is important to give it a unique file name and save it. To do this go to the File menu and select Save or press Amiga-S. MiAmiga File will display a dialog box asking you the name of the file you wish to save. Let us name our file Members. Enter the file name with an .FLR extension to allow MiAmiga File to identify it as a file. The next time you save, MiAmiga File will automatically save the updated version on your disk. Again, remember to make a backup! Changing Your File Now that we have created a new file, given it a unique file name, saved it and made a backup copy, let's make a few changes. As stated previously, you can add to, delete or rearrange your record in number of ways. In our file "Members.FLR" let's add the weight field again. CHAPTER FOUR Building A File Overview This chapter describes and illustrates the way you enter, edit and save records in your file. We will discuss the differences between the form and list formats, and you will learn how to obtain information about the fields and file you are working with. Forms vs Lists In the previous chapter, we introduced the list format. You selectd this format from the Options menu at the top of your window screen. This format showed you some of the fields or columns in your record. The remaining fields could be viewed by using the horizontal scroll bar at the bottom of the screen. In chapter 6 we will see that the list format is also used when we wish to view some or all of the records in our file. The form format, on the other hand, is what we use to enter new data into our file. To get to the form format go to the Option menu and select Form. Your window will display the fields of your record and the data you have entered. The ability to rearrange the layout of the form format, is another of MiAmiga Files' special features. In our sample record, you may not be able to view all of your fields at once. Therefore, you may wish to place two or three fields on one line. This is accomplished by placing the pointer on the field name and dragging it to the location of your choice. In our sample file try this by placing the zip code on a different line from the city and state. You may have noticed that you cannot view the entire line of data at once. MiAmiga File allows you to lengthen or shorten any of your fields. Position the pointer on the right line of the field box titled "address" and drag it to the right to lengthen it. To shorten a field, place the pointer on the right line of the field box labeled "city"and drag it to the left. Do this with state, until you are able to view the entire line of data. In the next section we will show you how to view the remaining fields of your record. The Left Scroll Bar In the form format, as in the list format, we may have more fields in our record than the window can display at one time. MiAmiga File utilizes a third scroll bar to view more of the form. The vertical scroll bar at the left of your screen is used in the same manner as the one on your right. By placing the pointer at the arrow on the bottom of the bar and clicking, you are able to view the remaining fields of the form. Again, if you wish to view the form a little faster, place the pointer in the box of the scroll bar and drag up, to see the top of the form or down to view the bottom. Entering Information in the Form Format At this point, if you are not at the beginning of your record, scroll back with the left scroll bar to the top of the form. We are now ready to enter our first record. The first field which you see, is the name field. The first half of the field will state the field name, the second half is where the I-beam will automatically appear. Type in the last name, and first name of your first member (i.e. Nelson, C), and then press the Return or Tab key. You will notice that by pressing the return or tab key, the I-beam proceeds to the next field. In our sample file this is the adress field. Start typing in the address for C Nelson as follows; 1234 Hubbard Lane. If your address field is too short, MiAmiga File will scroll the information for you. We have discussed previously in this chapter how to lengthen, shorten or move fields within the format. After you have entered the information for address, fill in the remainder of your record as follows: Field Information City Grants Pass State Oregon Zip Code 12345 Amount Paid 500.00 Date Joined 07/26/86 # of Years 4 Height 5'11" Weight 165 Renewed Yes Phone (805)123-1234 It is always a good idea before adding a record to your file to check its contents. To do this simply scroll back to the top of the form and review your work. Adding Records to Your File Now that you have checked your work, you are ready to add this record to your file. This is accomplished ineither of the following ways; Place the pointer at the box on the bottom of your screen labeled "accept" and press the button,or If you are in the last field of your record, just press the Return key. What About Errors We mentioned above, that you should check your record to be certain the information you entered is correct. There may be a few times when you will notice an error or two in the way you entered your data. There are a couple of options available to you to remedy this situation. For example, you have just entered the data in the last field of your formated record and you discover an error in the name field. By pressing the Tab key, MiAmiga File will bring you back to the beginning of your record. You have also noticed that you put the height of the first member in the height and weight fields. The information on his weight has been lost and therefore you need to create a blank field. By pressing Tab or Return you will leave the field blank and MiAmiga File will bring you to the next field in your record. After you have made the corrections to your record, place the pointer in the Accept box at the bottom of your screen and click. The other options on the bottom of your screen are; delete, new and undo. The delete command erases the entire record from your file. A dialog box will appear to ask if you are sure you want to do this. The new option is another way for you to proceed to a new format. The undo command is used to change information in a field which you may have entered incorrectly. Now that you have made the changes to your records and accepted them to your file, it is time to save the newly created file. Have I Saved My Records There is a difference between accepting a record and saving a record. When you accept a record, it is saved in memory but not on the disk. To save records permanently, go to the File menu and select Save. You should save and backup your file as soon as possible to ensure against loss of information. The Abandon Feature This option is reached by going to the File menu and selecting Abandon. It is used to eliminate any records you may have added, changed or deleted by mistake. You will, however, lose all of the unsaved changes you have made to your file. The Abandon Feature will also close the file automatically, and you will have to go to the file menu to reopen the original file. A dialog box will appear and ask if you are sure about this action. Characteristics of Your File To obtain information on the file you are working with, go to the File menu and select Status. A dialog box will appear. As you can see, the information in this box is specific to the file you are working with. It provides the file name, the number of records in the file, the average size of each of the records, and the approximate number of records that the file will hold. The percent unused refers to the amount of storage still available for use. To return to your file, press OK and MiAmiga File will bring you back to the record you were working with. CHAPTER FIVE Output - Printing Your Files Overview The purpose of this chapter is to present the different aspects of output processing. We will discuss not only the activities of moving data to and from memory, but also the characteristics of output options available to you. This chapter is divided into five sections. The first concerns the characteristics and format of Labels. The second section describes Listings and the third discusses Screen Prints. Combining MiAmiga File files with your word processor, is the subject of the fourth section. Finally, the last section describes printing your text files. Printing Labels The first step in printing labels, is to return to the Form format. In chapter four we discussed the different ways of changing the format of the form. Reviewing some of these changes will assist us in printing our labels. When printing labels, we need to place all of the information we need to print on the first five lines of the form. Any information below the fifth line will not print. In our sample file, Members.FLR, the form of our record was created as follows; Name | Nelson, C Address | 1234 Hubbard Lane City | Grants Pass State | Oregon Zip Code | 12345 Amount Paid | 500.00 Date Joined | 07/26/85 # of Years | 4 Height | 5'11" Weight | 165 Membership | Yes Phone | (805)123-1234 We could leave the record in this format because, all of the data needed to print a name and address label is incorporated within the five line limit. If we wanted a more conventional format for name and address labels, we would have to make a few changes. You should keep in mind, when making these changes, that MiAmiga File will print the first thirty characters of each line. Let us experiment with the format, and change the form to conform to the standard name and address label. Name, of course, is fine in the number one position. You may want to lengthen or shorten the field by placing the pointer on the right line of the field box, and moving it to the right or left or by adding a first name field to you record. Next, create a blank line by moving the address field down one line. To do this place the pointer in the left side of the field box, click and drag the field down. Again, as with the name field, you can lengthen or shorten this field to the desired length. Now, create another blank line. The next three fields; city, state and zip code, can all be placed on the fifth line. You can leave city in the same position it is in and drag state and zip code up respectively. MiAmiga File will automatically place one space between fields for you. If you desire a larger space, simply adjust the field to the right or left. If there are any remaining fields within these five lines, and you do not wish them to be printed, move them down below the five line limit. Upon the completion of entering your data, you have two different output options available. The first is to put the file out to the printer. To do this, select To Printer from the Print menu. The second choice is also selected from the Print menu. To print an ASCII File, select To ASCII Disk File. Printing Your Lists In order to print your labels in the last section, you had to return to the form format. Likewise, when printing lists, you need to return to the list format. Your printed file will look exactly the way it appears on the screen. You can delete, move and change the width of the columns to suit the desired output. You have two choices when creating a printed report. To print on the 11" wide computer paper, select 132 columns from the Print menu. If you are using the 8 1/2" size paper, select 80 columns from the Print menu. If your printer can accomodate both sizes, be sure to place the correct form in the printer. Using the sample file, as an example, create a printed report for all of the members in the health club. Leave the height and weight fields off the report and move the new membership field in front of the # of years field. The first step is to "Hide" the columns; height and weight. This is done by clicking on the field name, height, at the top of the window, going to the column menu and selecting Hide. This column will be grayed out on your screen to let you know it will be hidden from the printed report. Now, do the same with the weight field. Next, we need to move the field, new membership, in front of the # of years field. To move a column, place the pointer in the field name, hold down the button and drag to the desired location. If you are using 8 1/2" paper, your printed report will appear as it is in the window. As we discussed in the labels section, you have your choice of two output files. The first, a printed report, is selected from the print menu with the To Print option. The remaining file is an ASCII File. This option is also selected from the print menu. Note: If you have an amount field in your file, (Amount Paid in our sample file) MiAmiga File will total the field at the end of the report for you. If the total amount of the fields is greater than the computation capacity of MiAmiga File a question mark will appear in that field. Printing One Screen Only MiAmiga File will print one screen of information whether it is in the form or list format. You can still rearrange the columns of the list, or fields of the form, in any way you need. After customizing your screen, press Amiga (the right key) Help to print. CHAPTER SIX Accessing and Updating Your Information Overview This chapter concerns the structure and design of MiAmiga File. It has two major sections. The first section discusses the information in the form format. We will survey this because it will help us to structure and evaluate our individual records. In the second section, the information in the list format is discussed. This discussion includes: sorting, hiding and showing columns, changing numeric format and other topics that lead to the criteria for evaluating and designing an effective file. Accessing A File To help explain all of MiAmiga Files features, let us go to the file menu and select Open. The sample file which we created in the previous chapters will be listed. To open our file, Members.FLR, type in Members.FLR and click OK. Now that we are in our file go to the options menu and select Form. This will bring up the form format and allow us to work with some of the records we previously created. The Form Layout As we explained in chapter four, the form format is used to enter new data into our file. Once the data has been entered, accepted and saved permanently on your disk file, you are able to scan it any time you access the file. To accomplish this, click the number of the record in the left margin you wish to examine. All of the fields in that record will be shown. If there are a few fields in your record which are not shown, use the left scroll bar to view the remainder of the record. If you need to center or include any editing features for an entire field, you will have to go to the list format to structure these changes. Making Changes in Form Format Once you have accessed your record in the form format by choosing the number of the record in the left margin, you are ready to update it. In our sample file Members.FLR, you may need to extend a membership, delete a record (due to an expired membership) or change an address field for one or more of your members. You will see the I-beam in the first field of your record. In our file we may need to change the address of one of the members. By pressing the Tab or Return key, you will move to the text field. To delete the information already in this field, use the Backspace key. Now you are ready to enter the new address. If you check your work and discover an error, click the Undo button at the bottom of your screen. Remember that when you click the Undo button, it will return the record to the original data that has been stored there. After you have updated all the information in your record, go to the bottom of your window and click Accept. The next change in our sample file, is to delete an entire record. Again, choose a record from the file for this purpose. After you have examined the record and are sure that this membership has expired, go to the bottom of the window and select Delete. A dialog box will ask if you are sure of this action. In this section, you have learned how to view your records in the form format and how access one or more of them in order to update your file. The form format does not allow you to sort your records, center your columns or edit amount fields. This is accomplished in the next section under the list format. Remember that any changes you make to your records have to be accepted and then saved permanently to your disk file. In section two, we will discuss how to examine and modify the existing records in your file using the list format. To go from the form format to the list format, place the pointer on the bottom of the form (except on the boxes) and click. SECTION TWO, THE LIST FORMAT Overview Section two deals with the structure and organization of your files. We will discuss five main topics, starting with Columns. The second topic is the use of the grid and how to turn it on and off. Third we will be showing you how to title your file, and therefore have a title on each of your printed reports. The fourth and fifth topics deal with the selection process and sorting of the records in your file. Columns Hiding and Showing In chapter five, when we printed our sample file, we explained how to hide specific files. This was done on two fields, height and weight. To hide any specific field from the actual printed report, click on the field name at the top of the column and select Hide from the Column menu. If at this point we would like to show the column of height, we would click on the field name again and Select Show from the Column menu. There are two other choices in the column menu dealing with the hiding and showing of columns. Hide All can be used when you wish to display a couple of fields. By selecting this option all the fields will be grayed out (hidden from the printed report) and you can select the few columns you wish to show by clicking on those specific fields. Show All will exhibit all the fields once more. When you select the Hide option, MiAmiga File will automatically adjust your columns on your printed report. In our sample file, we have an amount field. We need to display this field with dollar signs, commas and two decimal positions. To change the format of the Amount Paid column, click on the field name and select Format from the column menu. A dialog box will appear on the screen. The format option allows you to place dollar signs, commas and zero, one or two decimal points. The dollar sign will be placed in front of the amount. Commas are automatically placed between every three digits and the decimal point is placed in one of the three positions you choose. Rearranging MiAmiga File provides for maximum flexibility when displaying your information in your window and on a printed report. The ability to change the width, hide a specific field and or move several fields around, allows you to be extremely creative in producing customized final reports. You can move one or more fields in your record. To move a field, place the pointer in the field box name you wish to move, hold down the button and drag to the new location. Changing the width of a field is done by placing the pointer on the dotted line between fields and dragging to the right to lengthen the field or to the left to shorten it. Remember, once you change your record you must save the updated version to disk in order to make a permanent change. Don't forget to back it up! Text Alignment Each of the columns in your list can be aligned in one of three ways. When choosing one of the three options, it is customary to stay with that choice for the entire field. In our sample file, we can experiment with the different options. To change the alignment on any field, click on the field name on the top of the column and select one of the three options; left, right or center, from the Column menu. On the name and address fields, select Left from the Column menu. You will notice that these fields will automatically be left justified. Finally, select Center from the Column menu for the fields; Height, Weight, New Membership and Phone. You will notice that these four fields are now centered within their respective columns. Operating the Grid MiAmiga File provides a useful grid for entering data in columns and rows. This will automatically appear in the window when you select List from the options menu. To turn the grid on or off, go to the Options menu and select Grid On/Off. This option will provide both functions. Although the grid is presently in the off phase, you are still able to alter the width of your individual fields. Place the pointer on the right side of the field you wish to alter and glide to the left, to shorten your field, or to the right to lengthen it. Naming Your Window When we created our sample file, we needed to provide MiAmiga File with a unique file name. This file name is used whenever we need to access the file. When you open the sample file, you will notice that the file name automatically appears in the top of your window screen. In printing a file, we may wish to be more specific as to the contents of the report. MiAmiga File provides another option in the file menu for this purpose. To change the name on the top of the screen, go to the File menu and Select title. With a maximum of forty characters, type in the name of the report and click the OK button. The new title will appear at the top of the window, and will be printed on your report. This, however, does not change the name of your file. After printing this report, go to the file menu and save your changes permanently on your disk. Selecting Groups of Records MiAmiga File provides two types of selection for records. The first of these is the ability to choose by example. In choosing by example, you set up specific guidelines which have to be met. The second option is to choose by range. The range is set in terms of a beginning and ending point in your field. If you are not satisfied with the conditions you have chosen, you can reset the conditions of the field by selecting them again. By Example In our sample file we want to locate all of the members with a membership of four or more years. Setting the guidelines for selecting groups of records is accomplished by choosing By Example from the Select menu. First click on the field name; # of years at the top of the column, the field name will be highlighted to let you know this is the field you are working with. Next, go to the Select menu and choose By Example. MiAmiga File will provide a dialog box to prompt you for specific information. The first line of the dialog box has an In and Ex box, meaning include and exclude. The include box will incorporate the records that meet the criteria you set up. The exclude box, on the other hand, will not list the records which meet the required criteria, but will list all of the other records in your file. In our report we will click the In box, because we wish to list all of the members who meet the criteria. The next line of information is provided by MiAmiga File. This is the field name you choose from the list on your window. The field that should appear here is; # of years. Now we need to select the conditions we want to meet. MiAmiga File has the following conditions to choose from; equal to (=), not equal to (<>), less than (<), greater than (>), less than or equal to (<=), greater than or equal to (>=), and contains (*). If you are searching for a particular string of characters, contains will locate and display all of the records which contain them. The condition we need to set is, greater than or equal to (<=) in order to accomodate the criteria of four or more years. Click on this box. The following line is where you will type in the specific information. This field will accept both alpha and text field types. For our purposes type in the number 4. When you click the OK button, MiAmiga File will automatically list the selected records on your window. By Range Selecting groups of records by range is the second option available for use. In our file, let's select the Amount Paid field to see how many members have paid fees between 500 and 600 dollars. After you have highlighted the field name, Amount Paid, go to the Select menu and choose By Range. MiAmiga File will display another dialog box. You will notice that by range option also displays an In and Ex choice in the first line. These options operate in the same manner as in the By Example format. In our list we want to include all of the members who have paid between five and six hundred dollars, therefore we need to click on In. The next line is again where the field name will automatically appear and should be the same as the one we highlighted earlier. If Amount Paid does not appear here, click on the cancel button and begin again. The next two lines will set the range. On the first line, is from, you will type in the low value of your search. If this field is left blank, MiAmiga File will automatically begin at the lowest value. On the second line, through, you will type the high value of the search. In our file the from value is 500.00 and the through value is 600.00. When entering information in these fields do not use dollar signs or commas. Once the criteria is set, click on the OK button. Full vs Selected List The above example will provide us with a Full List of all the members who fall in the five to six hundred dollar range. We can narrow the list down by adding the previous criteria of four or more years as a member. This will provide us with a selected list of our records. To return to the full list, select Full List from the select menu. Sorting MiAmiga File has two types of sorts. The first, single column sort, will sort a field in an ascending or descending order. To sort fields within fields, you have the option of choosing a progressive sort. Single Column Sorting In our file, Listings.FLR, we need a list of all our members in alphabetical order. To accomplish this we first have to go to the name field, Name, on the top of the column. The next step is to proceed to the Sort menu and select Single Column. Next, we have the choice of providing an ascending or descending sequence of our records. Because we would like the list in alphabetical order, we will click on the Low To High choice. A check mark will indicate that this option has been activated. If we needed a descending sequence, we would choose from High To Low. You will notice that all of the records are listed in alphabetical order with a number for each record in the left hand column of your window. Progressive Sorting Progressive sorting means that we are sorting a field within another field. With MiAmiga File this is done by first choosing a single field to sort. In our file let's choose the city field. Highlight this field by clicking at the top of that column. Now, go to the Sort menu and select Single Column and Low To High. Single sort must be done prior to a progressive sort. Next, we would like an alphabetical listing of our members within each city. To begin a progressive sort, go to the Sort menu and select Progressive. Now, go to the column heading titled; Name and highlight it. Return once more to the sort menu and, once again, select Low To High. Progressive sorts provide you with a more detailed output of your entire file. You can locate specific information faster and more efficiently. To begin another progressive sort, repeat the instructions above.