repeat post pls help

[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

[Murray *ACE*]

Rajiv:

You may have better luck posting this on the dreamweaver.appdev forum.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================

"Rajiv Vaishnav" <ra...@vaishnavs.com> wrote in message
news:fqaje1$mja$1...@forums.macromedia.com...