Aeos - the data types are different as well ???
hmmmmmmmmmmmmmm
why not create another table that has what you want -
and append from your last known 'good' table ??
Be specific about field order and data type when you make the new table.
hth - mondo regards [Bill]
>hello there,
>
>I have two tables with the same fields but sequence of the fields are different.
>I use the validate database command but after validate,the fields in the correct sequence but the data type not moving with the field name.