Using the Sequential Numbering Feature


    This feature can be used for numbering invoices, customer records,
products or any records in general.

    Below are the steps necessary for automatically numbering any new records
in your database and also for numbering existing records.

    If you want to increment the @NUMBER by more than one, use @NUMBER(n)
where "n" is the amount of the increment.


    HOW TO NUMBER EVERY NEW RECORD THAT IS ADDED

        F-File <enter>
        D-Design File - choose your filename.dtf <enter>
        C-Customize <enter>
        I-Set Initial Value <enter>
          tab to the field where you would like the number to appear
          (for this example we will refer to it as RECORD NUMBER), type:

        @NUMBER <f10>
        Choose F-Format Values <enter>
        Tab to the RECORD NUMBER field and type an "N" (no quotes) after the
        number field <f10>
        Global Format Options <f10>


    HOW TO RESET @NUMBER

        F-File <enter>
        A-Add Data <enter>
    Press CTRL-F8, the Reset @NUMBER box will appear, reset the @NUMBER value
to one less than the number you would like to used as your next number.


HOW TO NUMBER ALL PREVIOUS  RECORDS

       F-File <enter>
       M-Mass Update <enter>
       Retrieve Spec, press <f10> to retrieve all records


    Update Spec, tab to the RECORD NUMBER field and type:

       #1 = @NUMBER <f10>
            Choose "NO" to confirming each update individually.


 







Q & A Application Note       Rev. 6/92           #2102     Page 1 of 1