>>>>I'm user of Visual Fox Pro 3.0 and I've problems with the command 'SET RELATION'. I'm using GRID and RELATION between two tables, then when I cancel the relation with 'SET RELATION TO' or 'SET RELATION OFF' the child table doesn't show all the registers, but the same registers that was been showed before to cancel the relation. I'd like to see all the registers of child table. What do I do?
>>>
>>>myGrid.Refresh()
>>
>>Yes, I know about that command. But I've already tried and in this case it doesn't work. I don't know if it's a problem of the verson of Visual Fox Pro that is 3.0, because that command doesn't work with the command VIEW. I also tried the command SET REFRESH, and nothing.
>
>Fernando,
>
>I'm a bit perplexed.
>
>Is your recordsource a table, alias, cursor, or a query?
>
>SUSPend the program and move around in the child with the command box. Can you see all the records now?
>Look at your data session window. are you sure that the relation is broken?
>
>HTH

To add to Matt's idea, when you cancel the relation are you SURE you're in the correct SELECT area? You must SELECT Parent then SET Relation TO.

HTH
Barbara