>i have table a and table b, table a being the parent and b being the child linked by the id field. I have a grid on a form with properties currently set as follows.
>
>linkmaster = a
>recordsource = b
>relationalexpr = id
>childorder = id
>
>table b is the table that i want as the record source, and i want it to move whenever the parent table moves (one to many) this works fine, my only problem is i want the order of the grid to be in reverse order, currently when i add a record it appears at the bottom of the grid, i want it to appear at the top.
>Can somebody please head me in the right direction.
>Thanks
>James

The record will appear in the grid in the order that the ordered field falls. If you index is on SomeTextField DESC, and you add a blank record, it will fall at the end of the table. If you need it to go to the top, give SomeTextField a value that will place it at the top. Like "A".