pull down records from one table to another through forms

[suman]

Hi all
I am trying to build an Inventory Control Software in Access 2003
A short description of my tables
df_item
item_ix PK autonumber
item_cd text
item_title text
ti_enq
enq_ix PK autonumber
enq_no text
enq_dt date
ti_enq_detl
enq_ix Long Int (related with ti_enq.enq_ix)
enq_detl_ix Pk autonumber
item_ix Long int (related with df_item.item_ix)
Qty Number
ti_ord
ord_ix PK autonumber
ord_no text
ord_dt date
enq_ix Long int (related with ti_enq.enq_ix)
ti_ord_detl
ord_ix Long int (related with ti_ord.ord_ix)
ord_detl_ix PK autonumber
item_ix Long Int (related with df_item.item_ix)
qty number
rate number

I have made a form named "Enquiry" with subform based on tables df_item,ti_enq and ti_enq_detl
Now I am trying to create a form named "Order" with subform "Order Details".
But here I am facing a problem. Which is.......
suppose I create an enquiry with 10 items.(Let the enq_no-01)
And now I am trying to make an order considering that enquiry.
In forms "Order" I have enq_ix. Now I want that when I select a particular enq_no(001) in forms "Order" the 10 items for that enquiry will appears in "order details" subform. aginst which I made up the order for 5 items. then for the next time when I select the same enq_no the remaining 5 items will appear and so on.
How could it be done?

please help me in SQL as I am not familiar in VBA

Thanks.