help with update in one to many relationship

[Newsgroup_User]

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

[Sky Chief]

If you are using MS Access and relationships just edit the master table information. The related records will update automatically after the update is submitted to the master table.

One thing - I am assuming that the relationships you created also include your selecting the update and delete options in the relationships dialogue box being checked.