working with 'orderdetail' table in dreamweaver...

  • penguin83
  • Born
  • Born
  • penguin83
  • Posts: 4

Post 3+ Months Ago

Hey guys,

I am a student on placement designing a web based database for a company... im a little stuck! and was hoping some one could help point me the right direction?

I have order, orderdetail and product tables in the database, the order detail table solving the many to many relationship between orders and products. My problem is how to work with this in Dreamweaver, information needs to be added into both order and order detail tables to store the order info. I then need to be able to search, delete and update this info. I don't know how to work with two tables at once and there does need to be two because of the many to many relationship.

Any ideas would be greatly appreciated... im beginning to panic! :cry:

Thanks
penguin :D
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • penguin83
  • Born
  • Born
  • penguin83
  • Posts: 4

Post 3+ Months Ago

sorry forgot to mention...
im using ASP and SQL Server
(yes i know i should have used Visual Studio but the project is too far along now to change)
  • penguin83
  • Born
  • Born
  • penguin83
  • Posts: 4

Post 3+ Months Ago

sorry forgot to mention...
im using ASP and SQL Server
(yes i know i should have used Visual Studio but the project is too far along now to change)
  • righteous_trespasser
  • Scuffle
  • Genius
  • User avatar
  • Posts: 6230
  • Loc: South-Africa

Post 3+ Months Ago

well this depends, I know a little bit about this, not too much, but I may be able to help, can you give a little bit more detail, firstly, the columns in each table and how they are related, and then an example of what you'd like to update, delete, or add so I can be a bit more specific about my answer ...

Post Information

  • Total Posts in this topic: 4 posts
  • Users browsing this forum: No registered users and 41 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.