Adding a number to each record

[TaiChi56]

I have a database that has 1060 records. I just realized that I would like for each record to have a number, such as 1, 2, 3 etc.

So when I print there is a column that has this ID number. How would I add this field now and have it assign a number to each record? Thank you.

[LaRetta]

To add a serial to your table: On your serial field, select Options > Auto-Enter tab > Serial increment by 1. Then go to a layout with this serial field. Show All Records then place your cursor in the serial field (on any record). Select Records > Replace Field Contents > Serial Initial 1 and Increment 1. Be sure to click the checkbox to update auto-enter serial (you just created in field definitions).

To simply display the record NUMBER of a found set (which changes when sorted) for printing onto forms and such, go into Layout Mode and (using the text tool) type @@.

LaRetta

[TaiChi56]

Thank you LaRetta it worked perfectly.