Well...I have to create a sale detail table consisted of quantity and
product and has to have reference to the product table
and the order table as well.
so
Create table [sales detail]
(
OrderNo int,
ProductId char (5),
add constraint pk_sales_detail primary key(OrderNo, ProductId),
Quantity int not null,
ProductName varchar(50) not null
)
alter table [sales detail]
add constraint
fk_OrderNo_sales_detail foreign key (OrderNo) references
Orders (OrderNo) ///This works fine
alter table [sales detail]
add constraint fk_ProductId_sale_detail foreign key (ProductId)
references Products (ProductId) ///This gives me errors about no
///indicate primary key or something
Also note that: the ProductId in the Products Table is part of the composite key. Not sure if that is the cause of the problem.
create table orders
(
OrderNo Int,
constraint pk_OrderNo primary key (OrderNo),
OrderDate Date not null,
CustomerNo char(4) not null,
SalesRep char(3) not null
)
create table products
(
ManufacturerId char(3),
Check(ManufacturerId like '[A-Z][A-Z][A-Z]'),
ProductId char(5),
Check(productId like '[A-Z][A-Z][0-9][0-9][0-9]'),
constraint pk_ManufactureId primary key (ManufacturerID, ProductID),
Description varchar(50) not null,
Price money not null,
QtyOnHand int not null
)
Here is what I would like to do: Add a “Sales Detail” table to your database.
This table is related to the Orders and Products tables. It shows the product and quantity ordered at least
