Help wiht database design

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 AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200702/1

.

Relevant Pages

  • RE: form updates the table, but the query doesnt show it
    ... (the feeling that i'm going to have to rebuild this database from scratch ... repair information. ... the lines of Pertaining to Customer Claim of Trouble vs. Pertaining to Repair ... based it on the query. ...
    (microsoft.public.access.queries)
  • form updates the table, but the query doesnt show it
    ... formed the original database with intent to make it more efficient / logical ... repair information. ... the lines of Pertaining to Customer Claim of Trouble vs. Pertaining to Repair ... based it on the query. ...
    (microsoft.public.access.queries)
  • Re: order by property in a table
    ... SQL or query that retrieves the records, or some property of the display (a ... Do you have the database you are developing separated into a front-end ... > create a database to track customer traffic, not customer information). ...
    (comp.databases.ms-access)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: OT: SQL
    ... query processing. ... FROM Employees e, Employees m, Management mgt ... Manager and Employee Salaries. ... The scheme used does not model database files in general, ...
    (sci.logic)