Simple Database Design question

[jomns]

I am working on a project assignment for my school.
The design of the database is attached to this thread.
The problem is on the Orders_table. I don't know how to implement the order_table with more than one product ordered.
So i thought i could be an idea to create an orders_table with a table Id, so i could use the same order_number for the several ordered products. And then another table total_order where I take the order_number and the total price.

Does anyone have an idea about some other approach.

Thanks,

Jonathan

[tsinka]

Hi what about this

Customer_table:
Customer_ID
Name
Aftername
Address
Postcode
City
Tel
Mobile
UsrName
Passwd
Email

Products_table:
Product_ID
Product_Name
Price

Orders_Table
Order_ID
Customer_ID
Order_Number
Time
Date
Total_Price
Status

And now another table that simply maps the ordered products to an order:

Product2Order:
Order_ID
Product_ID
Price (Add this field if the Product prices change from time to time so you can see what the product price was when it was purchased)

Thomas