I would like to place a GRID on a form that is to display the zipcodes which are serviced by a particular salesman.
The zipcodes will be entered (via another form) in the order that they become part of the salesman's territory. They may not be entered in numerical order but I wish to have them displayed in numerical order. I have them stored in a file called REPZIPS with order REPCODE1 which contains the expression REPCODE+ZIPCODE and also an order REPCODE which contains the expression REPCODE.

Problem: If I use REPCODE as the ChildOrder for the GRID and REPCODE as the relationalExpr the grid works fine but displays the zipcodes in the order they were entered. If I use REPCODE1 as the ChildOrder, the grid displays nothing.

Is this impossible to accomplish ?