That's what I'd normally do (and still might), but right now that does not seem to be the best solution.
>It might be easier to use a cursor that combines the tables for the grid data. If you need to reposition the pointer in your main data table, you can use the AfterRowColumnChange to position the cursor on the desired record.
>
>>I don't use this relational technique with grids much. Seems like it's never worked quite right, however. I'm hoping I'm wrong.
>>
>>>I don't have FoxPro at this office and it has been a very long time but it seems to me that in the past I have had to use some sort of scrolling method on the grid to get some things to behave correctly. I had to scroll to the next record and back again.
>>>
>>>>I don't find myself doing this much since I'm using the contents of a SQL statement so often, however I need to have one column of a grid display a field from a related table. I have the SET RELATION set up properly, of course, and this seemed to work fine a week or so ago, but now I come back to the form that contains the grid to try to finish it - it got put on the back burner for awhile - and now it's not working. Is there a trick to this?
>>>>
>>>>Russell Campbell