Did you perform a Grid.refresh() after the Append?
-Irv.

>Dear Irv,
>
>Thanks for your reply,
>
>I tried removing and reinstating the relationship between Orders and Shipment table. It works OK for appending record. But even after restoring the Relationship the Grid does not display SHIPMENT records, it becomes blank.
>
>Pl Suggest what to do?
>
>Regards
>Shaishav
>
>>Shaishav:
>>
>>This is expected behavior because you have one DE with a specified Relation. It will always point to the first Child record it finds.
>>
>>To remedy this you could:
>>
>>Use another Form with its own Private DS and only the desired table 'Shipments' in it...
>>
>>Or, suspend the parent-child relationship temporarily, append the record and then reinstate it.
>>
>>HTH,
>>
>>-Irv.
>>
>>
>>
>>>Dear All,
>>>
>>>I am facing some serious problems with respect to GRID RELATION and FORM REFRESH, I don't know its me or VFP is bugging me.
>>>
>>>I have created a formset, where I have two forms.
>>>
>>>I have 3 tables in DE, CUSTOMER, ORDERS AND SHIPMENT.
>>>
>>>The Realation is set as follows:
>>>
>>>CUSTOMER to ORDERS and ORDERS to SHIPMENT.
>>>
>>>I want to show like followin, in my main form I have a Combobox and two grids.
>>>
>>>Combobox allows me to select Customer, and both the grids will show the records of ORDERS and under ORDERS SHIPMENT details respectively of selected customer.
>>>
>>>It is working fine till here.
>>>
>>>Now I have another form in the same formset, Where users enter shipment details.
>>>
>>>I have an Add button on Main Form. By pressing which, a record is appended to SHIPMENT table, and the second form will be brought up, for user entry.
>>>I am storing Primary key of parent table (ORDERS) in SHIPMENT table's new record.
>>>
>>>However when the form is displayed, it automatically jumps to first related record in the SHIPMENT table.
>>>
>>>For eg;
>>>ORDERS Order_id 101, has two shipments 101-1 and 101-2. If I appe blan, and store 101-3 record, instead of showing 101-3 in my form, it shows data of 101-1.
>>>
>>>Can some one guide me what I am missing.
>>>
>>>Desperately seeking your help.