The following solution will work in either a ClarisWorks Spreadsheet or a Claris Impact table.
To number sequence records, create a new Spreadsheet or Table and put the following formula in cell A1:
=IF(ISBLANK(B1),_,1)
In cell A2, put the following formula:
=IF(ISBLANK(B2),_,A1+1)
Where an underscore (_) signifies a space.
NOTE: Claris Impact tables do not automatically show row or column headings. To show headings, select TABLE OPTIONS from the TABLE Menu and check "Column Headings" and "Row Headings".
Click on cell A2 and drag down the "A" column until you have selected a range of cells large enough to incorporate all of the records you will be numbering. Choose "Fill Down" from the Calculate menu (Table menu in Claris Impact and save the spreadsheet as "Record Numbering".
In the layout you've created to list your records, select all of the records you wish to number and copy. Open "Record Numbering", select cell B1, and paste.
There are some limitations to this procedure. When you paste into the spreadsheet or table, the columns will be in the order the fields were created. You may need to cut and paste columns until the desired order is reached.
Since the data is in a Spreadsheet or Table, you can use frames in either word processing or graphics frames to make the report more attractive.