Skip to main content
Inspiring
March 1, 2008
Question

help with update in one to many relationship

  • March 1, 2008
  • 1 reply
  • 249 views
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




This topic is closed to new replies. Start a new post to keep the conversation going.

1 reply

Participant
March 2, 2008
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.