Search results

My database structure is probably wrong but it was the only way i could think of to get a many to many between orders and products. So at checkout I'm looking at an insert for the customers details(Customer table), an insert for the price and quantity(ProductsOrders table)? So then how does the...

Ok, I'm making an fairly simple ecommerce site using asp.net and access with 4 database tables. Pic below. I'm required to produce a page which displays all the orders processed. To do this I made a simple select inner join statement SELECT Orders.*, ProductsOrders.ProductID...