updating data

[suman]

Hi,
i have 5 tables they are df_item,ti_enq,ti_enq_detl,ti_ord,ti_ord_detl
i created a form named enquiry with a subform considering records from ti_enq_detl
now i am trying to create a form named order in which where i want when i click enq_ix (Which is a primary key of table ti_enq with autonumber) only those items will appear in order detl subform against which no order have been made yet.
please help

 

[JamesMcS]

All you'd need to do is link your subform to your main form with enq_ix and its common field in the subform. If the subform is only ever going to show records with no orders, make a find-unmatched style query and base the subform on that.

 

[suman]

perhaps i am not clear.
what i actually want is only to pull down the pending items from table ti_enq_detl to table ti_ord_detl
table ti_ord has ord_ix,enq_ix
table ti_enq has enq_ix
table ti_enq_detl has item_ix,enq_ix
table ti_ord_detl has item_ix,ord_ix

 

[vbaInet]

A main form which has: subform linked to another subform which is also linked to another... so and so forth.