RE: QUERY DESIGN HELP

Can anyone help with this post, id be willing to pay for someone to help me
through this issue.

"Malhyp" wrote:

Im sorry i do have another table that has something similar to the following.
it might be where im going wrong.

tblProd
idProduct, custId, productName, categoryName.

tblProd is linked to all the other tables. It is in this table that I select
which custId, productName, categoryName the customer wants to be listed under.

"Malhyp" wrote:

Hi there, I would like to know how I should be creating my query. I have
listed an example of the database below.

DATABASE NAME
db1

DATABASE TABLES THEN FILEDS
tblCustomer: custId, name, sirName, location, phone.
tblProduct: prodId, productName, productName2
tblCategory: catId, categoryName
tblLocation locationId, location

At the moment I have a query that pulls all this info together. The problem
I have is that each customer has say for example 6 productNames that could
mix in with any of 6 categoryNames as well.

So when I create the query it shows the following as an example for one
customer only.

query1
custId, name, sirName, location, phone, productName, productName2,
categoryName
BOB1 BOB JONES MELB 00000 PINE PINUS
FURNITURE
BOB1 BOB JONES MELB 00000 PINE PINUS
FRAMING
BOB1 BOB JONES MELB 00000 HWD HARDWOOD FURNITURE
BOB1 BOB JONES MELB 00000 PINE PINUS
HOUSING
BOB1 BOB JONES MELB 00000 HWD HARDWOOD INTERNAL
BOB1 BOB JONES MELB 00000 PINE PINUS
EXTERNAL

So for each customer it shows 6 results.

Is this the correct way to create a query?

The main problem created by this query is that when I create a MAIL MERGE
using Outlook or Word it creates 6 seperate emails because of the 6 seperate
query results.

Any help is appreciated.

Cheers
Mally.
.

Relevant Pages

  • RE: DATABASE DESIGN HELP
    ... which custId, productName, categoryName the customer wants to be listed under. ... Then you would only get products that relate to a specific customer. ... At the moment I have a query that pulls all this info together. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Help wiht database design
    ... which custId, productName, categoryName the customer wants to be listed under. ... At the moment I have a query that pulls all this info together. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Help with openquery
    ... The problem is I am passing this query from SQL server to a progress ... 'select prod.name as ProductName, categ.name as CategoryName ... ...
    (microsoft.public.sqlserver.programming)
  • RE: QUERY DESIGN HELP
    ... which custId, productName, categoryName the customer wants to be listed under. ... At the moment I have a query that pulls all this info together. ...
    (microsoft.public.access.queries)
  • Help wiht database design
    ... I would like to know how I should be creating my query. ... listed an example of the database below. ... tblProduct: prodId, productName, productName2 ... have is that each customer has say for example 6 productNames that could mix ...
    (microsoft.public.access.tablesdbdesign)