Hi. I need some help for my online shopping table prototype. I want to be able to allow data to be entered which shows that customers can buy the same products. I can't do this because the Product ID is a primary key in the product table. So if someone wants to buy a bread say, then the database can only all allow one person to be able to purchase the bread.
Here is a picture of the relationship. There needs to be something that links Order details table to Product table so that I can have duplicate Product ID. I don't know if this is possible and if so how.
Any help would be very appreciated.
Here is a picture of the relationship. There needs to be something that links Order details table to Product table so that I can have duplicate Product ID. I don't know if this is possible and if so how.
Any help would be very appreciated.