hi
I have two tables and I have not assigned any PK or FK yet because I need any suggestion
tbl_salesreturns
ReturnreceiptNo
Customer_ID
Date
tbl_salesReturnsdetail
ReturnreceiptNo
Product_ID
Quantity
UnitPrice
I need to make the relationship to be like:
suppose that I have 2 customers and they returned products, the first customer has return receipt No 1052, and after a period of time the second customer returned products with receipt No 1052
in tbl_sales returns: More than one customer may has the same ReturnReceiptNo (the number of the receipt), that means that the ReturnReceiptNo could be entered into the table for each customer, so the ReturnReceiptNo couldn't be as PK.
in tbl_sales Returns detail: each ReturnReceiptNo has more than one product, but I want to prevent the duplication in the products within the same receipt.
I appreciate your help