>>>>>
>>>>>Insert Into ViewTable1(parent_id,other_id) Values (Parent.parent_id,Other.other_id)
>>>>>
>>>>>Am I getting warm?
>>>>
>>>>Yes, and it's not my suggestion :), it's normal VFP way. The idea is that when you add record to a view, it's not in table yet, i.e. your interface can have Cancel functionality before you will issue Tableupdate() to send data changes from view to table.
>>>
>>>I changed my insert command but I still need to move the record pointer before my insert appears!
>>>
>>>TIA --lincoln
>>
>>Do you issue Grid.Refresh, or at least Grid.Setfocus?
>
>I did issue a Grid.Refresh, It is before my EndIf if it makes a difference.
>I also noticed I get an Update Conflict message if I try to delete a record I just inserted!
Firstly, use table-buffered view (BufferModeOverride=5 for view). Secondly, Grid.Refresh must work, or it's something amazingly miraculous ...., you can fortify this command by Grid.Setfocus().
Edward Pikman
Independent Consultant