>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?