Search results

Won't consolidating 'order_overview' and 'ordered_products' cause data in the databse to be duplicated.. eventually clogging it up? Here is a newer database which has a nice form built so you can see how the ordering takes place. Simply select your Customer, then the Order, then the products...

Thanks for the replies. Firstly, I have loads of customers (100ish). Secondly, I have loads of products and every customer pays differently for each product so its not the case of just having 'price band A' and 'price band B'. ajetrumpet your solution sounds like it could work, Ill give it a...

Hi, I am creating a db that handles orders. My problem is that the products being sold are so at different prices depending on the customer. (e.g I am selling 100 burgers to Mcdonalds for £50 whereas to Burger King I am selling them for £35). Therefore I have split my 'Products' table into...

Perfect. Thanks mate

Hi, I am trying to set up a query which will filter out the 10 most recent additions by date. My table contains a 'Title' field and a 'Date Added' field. I am trying to get the 10 most recent titles up in a query so I can then create a report based on this. So far I have managed to single out...