Hi!

In addition to what already said:

In my base grid class I have a few method to approach problems related to grid reconstruction behaviors and columns re-binding behavior of grid. You can read about this more in the VFP Grids Part I article. In particular, for this kind of problem I created RecordSource_Assign method, where I remember parameters of columns before record source assigned, assign record source, then re-bind column control sources and set up widths of columns properly to what they were before.

HTH.

>Hi,
>
>my program uses grids to display data from various tables. The grids are based off of cursors that contain selected data from the tables.
>
>When I move from row to row in the controlling grid, inorder to update the other grids I am re-creating the cursors on 'AfterRowColChange' event and reassigning the record source for the grids.
>
>Master Grid - AfterRowColChange
>
>SELECT * from tableA where alltrim(upper(tableA.ID)) == alltrim(upper(MasterTbl.ID)) ;
>into cursor csrA NOFILTER
>
>SELECT * from tableB where alltrim(upper(tableB.ID)) == ALLTRIM(UPPER(MasterTbl.id)) ;
>into cursor csrB NOFILTER
>
>thisform.myfra.Apg.Agrd.recordsource = "csrA"
>thisform.myfra.Bpg.Bgrd.recordsource = "csrB"
>
>But this modifies the column widths in the grids although they are all defined in the design mode. How can I fix this?
>
>Thank you.
>
>
>Ria