I think you'll need to add a field. Somewhere in the documentation it says that the order of records returned by a SQL statement is random except for what's specified in the ORDER BY clause.
>Hi all,
>I have a one to many form which has a grid. In the parent table, users enter the Customer and date. In the grid, they add the Debits and Credits.
>When I write the SQL to retrieve results for a certain customer for a certain date, I order on CUST_NO, DATE. This changes the order of the records selected in the grid randomly. The users want to see the result in their reports in the same order as they appear in the grid. I would hate to add a new field which stores the order of the row. Any ideas??
>
>Thanks
>Abdul Ahad