>I have a grid that is part of a one to many relationship. The grid shows the many records, which works fine. The problem is the field order.
>
> In the grid I set the control source to a table called trandet. I have set the grid up to use text box controls. I have set the text boxs up to use the fields I want Ex:
>
>The data comes in as trandet.field1,trandet.field2,trandet.field3,etc..;
>I want the grid to show field5,field3,field6, in that order. I set the textbox controlsource in the fields in this order, but when I run the form the fields show up in the order of the table 1,2,3 ect..;
>
>Can't I control the field order of the grid display?
Hi William,
Set the corresponding column.controlsource in the desired order instead of textbox.controlsource
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison