Hi Erland,
yes everytime the customer places a new order, they will recieve a new CustomerFK within the Order table, the Link_OrderProduct table has the following keys;
- LinkID
- Order foreign key
- Product foreign key
as products can appear twice on an order, can I not validate on the
Order foreign key within the Link_OrderProduct table?
No comments:
Post a Comment