Recent content by danielemyr

Hello, I was wondering if you could help. I have a combo box that looks up a product number form another field but i also have a combo box in the next field that has product name. It would be much better if once you select a product code that the product name comes up automatically. I am quite...

Ye sorry. Basically SQF is a replacement so a product that needs to be sent out so a customer says that there missing a item or its broken etc then that information gets stored in that table. The related tables like SQF product is a way of keeping track of showing how many times a particular...

here is the relationship. I know its probably overly complicated and messy to what it needs to be. A lot of it isn't related to my question but here it is.

I have created a append query to find out how many individual orders there are and because of the way the relationship has been set up i can see how many product's that are attached to that order. So i have a table that just has a list of order numbers in if that helps.

Hello, I am working on a database at the moment to try and find the customer that has spent the most money. At the moment i can only get the customers that have placed the most orders. I have a dispatch table that consists of all the orders and a customer table that are linked using a Customer...