many to many

  • Thread starter Thread starter yaniv d
  • Start date Start date
Y

yaniv d

hi all,
i build a query that have the relationships of many to many.
in the report its working ok and there is no problem,
but in the form its loading too much and its very heavy,
?how can i decrease loading in the form and to make it more light
 
yaniv d said:
can you show me an example to this issue?
Click to expand...

Sure. In the Northwind sample database paste the following in a query SQL
window:

SELECT Customers.*
FROM Customers LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID
WHERE (((Orders.CustomerID) Is Null));

The Join shows all of the customers regardless of whether or not they have
orders, and the Where clause limits the customers to only those without any
orders.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top