>>I am in deep trouble since 2 weeks. Being new to VFP and afraid to trouble the valuable time of
>>this forum members, I was trying and trying to get out of the jam to no use.
>>
>>The Problem is simple.
>>
>>I want to create a from with child records in the grid. All controls and the grid are read only in the
>>beginning.
>>
>>When the user clicks add, I use memory variables to get the blank records and create a child table
>>cursor with create cursor.
>>
>>so far good
>>
>>The trrouble is when I save the record, it saves the master record and it dont save the child records
>>I have included the Begin trans roll back facility but it seems it is not working
>>
>>When the form gets refreshed after save, the complete structure of the grid gets changed.
>>When in add mode I turn on the addnew and the deletion property and turn it off in normal mode.
>>
>>Is there a serious flaw in the whole structure. Can anybody get me out of this hot soup.
>
>First of all, why do you use memory variables and child cursor?
>Why don't you use table buffering?
>
>You don't mention how you save your data from the child cursor to the real table.
>Assuming that you are using table buffering, do you issue a TableUpdate() for the child table after the save?

Hi.

Thank you for the reply.
First). I am using table buffering. I use child cursor so that the user will be able to add records without affecting
the table.

2. I copy the records of the child cursor into array and use insert(SQL) into the child table and then give the
tableupdate.

Any alternative method is most welcome.

Thanks

alex