Create the new table using the CREATE TABLE command, with the correct ordering of fields. Then APPEND FROM the original table.
>Dear Sir,
>
>I created a table, entitled table1, with table designer.
>The fields are as follows
>
>
>a n(1)
>b c(1)
>c n(2)
>d n(1)
>
>
>I want to change field order programatically as follows
>
>
>b c(1)
>a n(1)
>d n(1)
>c n(2)
>
>
>Is it possible to chage field order programatically,
>if then please help me.
>
>Thanks in advance
Steve Gibson