Francis, I have done this often by using an index on 2 fields (like your bcnudos and i), although only the first field is in the parent (master) table. I don't know what your difficulty is.
Have you checked in the debugger to be sure your table still has the correct index when the grid is active?
Are you sure the indexes exactly match? If you are using Upper() or allt() in an index that may be causing your problem.
Barbara
>Thank you for your answer, but my difficulty ise to have the records in the child database not only ordered on bcnudos but on both bcnudos and bclig and i do not know how to resolve it ?
>
>An idee perhaps ?