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.