>A grid shows fields that are stored in two related tables. At the moment I am creating a cursor with the combined fields and use that as recordsource of grid. If user changes the relating field in the grid, I need to show updated values in grid. One way is to recreate the combined cursor, but is there a way to make a grid show fields from two related tables without creating a combined cursor so that values in grid are automatically refreshed in the case described?
>
>TIA,
>
>Alex
Simply set the controlsource of the editboxes accordingly.
Yourgrid.column1.text1.controlsource='table1.field1'
Yourgrid.column2.text1.controlsource='table2.field1'
I also set the columns' controlsource to the same value, but I don't know if that's important. But as always, better safe than sorry. :-)