Dear Vlad,

Tks for ur help. I will try this as well.

Currently I hv decided to use separate forms with separte DE for both Orders as well as Shipment details. It is working quite well (so far).

However, while loading the SHIPMENT form (which has separate DE), it shows error message:

"Property settings will not take effect until data environment reloaded"

Error code is 1739. I don't know why this is happening.

When I looked at help for this error message, it suggests to execute Closetables and OpenTables methods of DE. I did that (put these statements in INIT of my form). Still it does not help.

Some times it shows me an empty GRID on this form, I tried recreating that GRID, but no use.

Pl let me know if you know anything about this.

Regards
Shaishav

>Hi!
>
>If you use parent-child relationship by SET RELATION command, it is a common problem with grids.
>
>With SET RELATION, each time record pointer is changed in the master table, the record pointer is child table is automatically moved to the first child record. When you use grids, during grid refreshing record pointer is moved automatically, thuis causingthe behaviour you described. Youc an solve the problem partially by remembering the current record in a child table, then restoring it just after you did all actions by using GO command to set record pointer explicitly to newly added record.
>
>Instead of SET RELATION command I would recommend you to use SET KEY filter, that works by the same way, but does not make connection with master record. You will require to change SET KEY setting for child tables each time record is changed in a master table. However, you will have much better control over grids refreshing, and no automatic record pointer changes.
>
>Hope this helps.
>
>>Dear All,
>>
>>I am using a formset with two forms. FRM_Orders and Frm_SHPT.
>>
>>I have 3 tables in my DE, CUSTOMER, ORDER and SHIPMENT.
>>All the tables are related in PARENT, CHILD and GRANDCHILD(?) relationship.
>>
>>CUSTOMER table has field Cust ID;
>>ORDER table gas fields Cust ID, Order ID;
>>SHIPMENT TABLE has fields Order ID, Shipment ID, Shipment_date, Shipment_qty.
>>
>>I gave a Combo Box (Cust_id) and two grids (ORDERS & SHIPMENT) on my FRM_Orders.
>>
>>FRM_Shipment is for accepting Shipment details.
>>
>>The Problem:
>>Whenever I add record to my SHIPMENT table, after append blank and replaceing appropriate foreign key fields (Order_ID), I display FRM_Shipment, for data entry.
>>
>>However, as soon as I display the form, the record pointer of SHIPMENT table moves to the top most record, instead of newly appended record, and displays that record data in the entry fields of FRM_Shipment form.
>>
>>I tried a lot to solve this problem, nothing works.
>>
>>Please Help.