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