Problem In Sqlserver Datafield ...pls Help

Hello frdz,

I m working with SQL SERVER 2005.

My problem is with the creation of foreign key for some table thru which i m not able to insert the data.

This table are samples i have included only main/few datafields and type from the table :

Please test and rectify if any errors...and tell me what's problem.What changes can be made to perform insert..


Table 1:Item

Fields :

itemid --> int identity ----- (p.k.)
qty --> int

Table 2: PurchaseOrder


Fields :

purchaseid --> int identity ----- (p.k.) error
itemid --> int ---- (p.k.,f.k.) not able to make purchaseid f.k. in purchasereturn ?
orderdate --> datetime

Table 3: PurchaseReturn


Fields :

purchasereturnid --> int identity ----- (p.k.)
purchaseid --> int ----- (f.k.) ???
itemid --> int ----- (f.k.)
returndate --> datetime

Table 4: ReceiptNote


Fields :

receiptid --> int identity ----- (p.k.)
purchaseid --> int ----- (p.k.)



Explanation :


Table 1:Item There are 100 records of items in table with all its basic details.

Table 2: PurchaseOrder The order placed by the customer can be as follows ....this is what i want to insert data into table.
Sample-1
orderdate --> June 14,2007

purchaseid --> 101
itemid --> 1,4,5,2,6,10

Sample-2
orderdate --> June 14,2007

purchaseid --> 102
itemid --> 1,6,10



There can be multiple items order placed for purchaseid 1.

Table 3:
PurchaseReturn The purchase return of items will be as per purchase of
items done.....this is what i want to insert data into table.
Sample-1
returndate --> June 20,2007

purchasereturnid --> 201
purchaseid --> 101
itemid --> 5,10

The items can be return as per purchaseid and items purchased.

Table 4: ReceiptNote The receiptnote contains the details of the purchase of items done and the payment made.


Hope to get a reply...after u view this topic

well can anyone test my table 2 & 3 fields in SQL SERVER 2005.There is problem in creating the table with foreign key...

ERROR : The column in table PurchaseOrder do not match an existing primary key or
UNIQUE constraint.

Thanxs in advance...