Reply to comment
The clist specifies which columns will be included in each returned record and how they are ordered in the returned record aggregate. Heres what a clist looks like:
or in URL-ese:
where each number is the fid of the field (column) you want returned, with a period separating the fids. The columns will be listed in the returned record in the same order as they appear in the clist. If you dont specify a clist, youll get your tables default columns and order.
If no column list parameter is supplied, then the default report layout and field order is used.
To change the default field order, select your table in the main application menubar, then click Customize->YourTableName Table->Forms->Edit the layout of the form. Select the field you want to move (or remove!) in the list, and click the Up, Down, or Remove button.