I suppose new programmer could write a 'utility' to go through the data after a PACK and re-adjust the fields containing a recno.

But your suggestion is best long term.


>New programmer says we should pack the data and rebuild indexes. Original developer said never pack the tables because she needs the recno(). I think new programmer needs to find how recno() is used and get rid of it.
>
>Much Thanks
>Miles