Sales Database - Not Working

[decmatt]

Hi

Can anyone help as to why this current set up does not work, I would like to input the order via a form, and have upto 5 products submitted at one time into an order. This can only be from the products in the table products. Any suggestions?

I have attached my current relationship set up

Thanks

http://img2.imageshack.us/img2/3929/relationshipsh.jpg

 

[lokkers]

Not entirely sure what you're asking here. I'd normalize between the order and order details table via a 1:* (many) relationship, rather than having rows 1-5. The order is a single entity, and the details hang off this.

 

[Participant]

does not work

Come on buddy we're not mind readers, I know you can do better than that.

Although I'm not sure that 'Detail' should be the primary key in your detail tab, as two orders might have the same detail e.g. '3mm screw' or whatever.

 

[jamief]

Item 1 through Item 5 are redundant.

Add a "Quantity" to the Order Details table (and consider renaming the table to OrderDetails).

To get the Product IDs in an order you would say

SELECT ProductId FROM OrderDetails
INNER JOIN Order ON Order.OrderID = @OrderId

or for product details

SELECT Products.* FROM Products
INNER JOIN Order ON Order.ProductId = Products.ProductId
WHERE Order.OrderId = @OrderId