Product Order by Customer history

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database for ordering products. The database contains Employees
(who placed the order) customers, products, payment methods, shipping
options. I have a form where I can view the customer and their order
history. What I want to to have a form OR a report, where I view the product
and a history of who ordered the product. I guess you can say vise-versa of
the form I have now, customer and order history.
 
I have a database for ordering products. The database contains Employees
(who placed the order) customers, products, payment methods, shipping
options. I have a form where I can view the customer and their order
history. What I want to to have a form OR a report, where I view the product
and a history of who ordered the product. I guess you can say vise-versa of
the form I have now, customer and order history.
Click to expand...

What is the structure of your tables? Do you have the typical Orders
table related one-to-many to an OrderDetails table, which is in turn
related many-to-one to the Products table?

If so you can base a Form on the Products table, with a Subform based
on a query joining the OrderDetails table to the Orders table (and
perhaps to the Customers table as well).

On a Report you can create a (non-updateable) query joining Customers
to Orders to OrderDetails to Products; use the Report's Sorting and
Grouping dialog to group by product and show customers.

John W. Vinson[MVP]
 
Back
Top