informix ms-access sort problem

I tried using ms-access(97) as a frontend to informix(7.23,cli 2.5). It worked, but i can sort only fields which are primary keys. (error: ....order by column (...) must be in select list (# -309)) -- Klaus Gotthardt, Johann Wolfgang Goethe-Universit't,Verwaltungsdatenverarbeitung Email: K.Gotthardt@em.uni-frankfurt.de Tel:+49 (0)69-798-23380 Fax:+49 (0)69-798-23381 Home,pgp-key: http://www.rz.uni-frankfurt.de/~gotthard