AHA! < s > Change the field name DESC to DESCRIPT (or something). DESC is a reserved word (DESCENDING, you know) and is confusing things. :-) This should do the trick.


>2. It's a simple character field called DESC that holds the description for the code it represents. It's not the PK or costcode.typeid. This field hold no special value, no relation to any other table or anything else.