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.