Re: Help wiht database design

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.

--
Message posted via http://www.accessmonster.com

.

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: 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)
  • 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)
  • RE: DATABASE DESIGN HELP
    ... More than one customer can select the same combination. ... 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)