MetallSummer
New member
- Local time
- Today, 23:09
- Joined
- Nov 10, 2021
- Messages
- 4
Hello to all,
I am making a database for one of my client and his products come with different sizes and extras. Each size has different price and the price of extras like cover, gift wrap etc. will also be according to the size of product.
I made two tables. Product and Product Sizes and then related them One-To-Many. I defined the prices in Product Sizes table accordingly. It went fine and then I made tables for orders. Again two tables with Order and Order Details and related them One-To-Many.
I dont know if I did it right or not because when I made a simple query and multiplied Unit Price with Quantity and I got strange results and I could not figure out where I made a mistake.
I would really appreciate if anyone can help me further.
Thanks in advance!
I am making a database for one of my client and his products come with different sizes and extras. Each size has different price and the price of extras like cover, gift wrap etc. will also be according to the size of product.
I made two tables. Product and Product Sizes and then related them One-To-Many. I defined the prices in Product Sizes table accordingly. It went fine and then I made tables for orders. Again two tables with Order and Order Details and related them One-To-Many.
I dont know if I did it right or not because when I made a simple query and multiplied Unit Price with Quantity and I got strange results and I could not figure out where I made a mistake.
I would really appreciate if anyone can help me further.
Thanks in advance!