>Hi Jim:
>
>The application I'm working on is located in several different offices both on stand alone systems and a network, there is an upload and download process
>that is processed on a RAS system for several of these offices (45) .
>
>I'm told that I must move all new fields before fields adddate and addtime which are the last fields in my main table.
>
>I thought I might use afields then copy all to new table but have been told
>I cannot do this without creating serious problems.
Sheena,

Position dependent fields in a relational database is a problem itself. In a relational database the only things the developer is supposed to depend on are the table name and the field name.

You may be able to do what you want but it wil not be easy. You will need to copy all of the data oput of the existing table to a temproary table. Then recreate the existing table completley so the fields are positioned where you want them. Since you will need to destroy the existing table before you can recreate it you will then need to recreate any indexes that existed and any relations that existed relaed tot that table. Once all of that has been done you will then need to append all of the data from the temporary table you created in the first place to save the data.