>While not a large table about 2000-3000 records it has losts of fields. He asked how hard
>would it be do re-sequence the fields so they are sequnecial (i.e. nolonger as missing
>values). Is there an efficent way of doing this? If so what is it?

Would it work for you to make copies of those tables, associate them with a DBC, set cascading referential integrity on updates, make your changes, and then copy the data back to the original tables?