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...