I have a grid on a form. The grid is to show zipcodes which have been assigned to sales representatives. The file holding these zipcodes (repzips) has fields: repcode and zipcode. It also has tags REPCODE (repcode) and REPCODE1 (repcode+zipcode).

The main file of representatives (reps) has a field called repcode also.

The relational Expression in the grid is repcode.

If set the child order in the grid is to REPCODE1 nothing shows up in the grid. If I set the child order to REPCODE everything works fine.

However, this is not desirable because then the zipcodes do are arranged in the order they were entered instead of numerical order.

Setting NEAR or EXACT doesn't seem to affect anything.

Any ideas ?