How do I reindex database.

[tangierc]

I want to reindex my database so that the number of records match the index number. There are already 1500 records. The database is not being used yet so it's ok for me to do this now, but I don't know how to tell FM to reindex all records.

Tangier

[Vaughan]

Go into the field definition, storage. Turn indexing off. Leave define fields. Then go back in and tuirn indexing on again.

[tangierc]

Thanks for that, but it didn't do anything. Maybe I did it wrong. What is appening is that my index field just adds an auto seial for each record.

Oddly the last entry is 1517 (for 1517 records), but the database only has 1502 records.

What I want to do is reindex so that the numbe of records matches the key index field.

FM 8

[Raybaudi]

Ok

If you haven't any related file based of your index, you can do this:

1) DEflag the autoenter option of a serial number of the index field

2) Make a new calculated field: RecordNumber with this calc.

Get(RecordID)

3) Sort record ascending by field RecordNumber

4) Put the cursor in the field index of the first record

5) From Record-->Replace Field contents...--> Replace with serial numbers, initial value 1, increment by 1

6) Look at the last number assigned to index

7) Flag the autoenter option of a serial number of the index field with "next value" = one more of your records

8) Delete the field RecordNumber