>>TABLE Fields and attributes: Code (C 3), Desc (C 50), Order (C 4), PKfld (I)
>
>Bob,
>
>In addition to what the other reply ahs told you I stringly suggest that you change the names of those field, DESC and ORDER are reserved words and will cause you problems, for eaxmple imagine this query;
>
>SELECT Order, DESC from tablename ORDER BY ORDER, DESC DESC ...
>
>Note the problem?
And Code is short for CODEPAGE - another reserved word...
Insanity: Doing the same thing over and over and expecting different results.