It's possible to change the order of records in a screen using fields that not been in the main table. I have a screen with contact, bpid, document. The fields bpid and document are fields of table tfacr200 and contact is a fields of tccom100 depending of bpid field of tfacr200. I need to order my records using contact, bpid and document.

Thanks in advance,
monica

before.program:
query.extend.select("tccom100.ccnt", EXTEND_APPEND)
query.extend.from("tccom100", EXTEND_APPEND)
query = "tccom100._index1 = {:tfacr200.ofbp}"
query.extend.where(query, EXTEND_APPEND)
query.extend.order("tccom100.ccnt, tfacr200.ofbp, tfacr200.ttyp, tfacr200.docn")