I have a table (1) that has 30 products.
I have another table (2) that has 5 fields. The first field is an autonumber, the second field has a lookup to the Customers table and the 3rd field has a look up to the other table to look up the product. The other two fields are entered.
At the moment, I have a query that joins table (1) and table (2) and pulls in information from both tables, however, it will only pull in the products that the customer has selected in table (2).
I need to create a query, that pulls in all 30 products for each customer, whether they have quantity of the product or not.
Is this possible?
I am using Access 2010. The database is a mix of web tables, queries and reports. the two tables I am trying to work with are Web tables.