problems updating one to many relationsihp

[Rajiv Vaishnav]

Hi friends,

I am using dreamweaver 8 and asp/vb/access for my intranet application

I am developing purchase order application where ihave following tables :

Order table

order_id
po_no
po_date
sup_id
etc

Order_detail table
orderdetail_id
order_id
product_id
quantity

Product table
product_id
product name

now i have related all these three tables

NOw on asp page i have a form with po_no, po_date, supplier name, text box
in it.

and i have an option to add items to Purchase order so it captures the
Order_id in session and enter records in order_detail table with more than
one products related to order_id

I have no problem in adding records to both the tables

but i have a question as once i entered a purchase order with 4-5 items how
to edit it ??? because for a particular order_id it may have more than one
product in that purchase order, how to get all the products in that
particular order_id for updation.

I hope i am clear about my query, kindly help me out, i am using
asp/vb/access and working in dreamweaver 8.

Please help me

thanks in advance.

regards
Rajiv