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.