Query help wanted!

[shyguy123]

Hi,
I have the attached Access database.
As you can see I have the following tables:
- brand_or_supplier: this is a list of all the brands, i.e. Nike, Adidas etc...
- buzzes: this is a points system telling me how many people 'liked' a product. This obviously is linked to the products table.
- category: each product is placed under a category, i.e. clothing, electronics etc...
- comment: people can leave comments for each product
- members: this is a table of members.
- products: a table of products
I need to relate each table in a new query. I have tried but it doesn't work. A member can create a new product. A product can have zero buzzes and increase in buzzes infinitely.
Can someone please help me with the query as it isn't right?
THanks,
Shy Guy

[orange]

Do not use lookups at the table field level. see http://access.mvps.org/access/lookupfields.htm It would be helpful if you could identify business facts: 1 Category represents a Group (1 or many) Products etc for each of your proposed tables.

[shyguy123]

Ok, thanks for the advice on not to use lookups.
In answer to your question, 1 category represents many products.

[orange]

I'm having trouble with the forum editor/response mechanism.
What I'd like is a list of facts for each of the things(proposed tables) you have identified.
Here's a sample (not necessarily related to your issue) to show you some Business facts.

 C. These THINGS are Related as follows : 
 - C.1 A CUSTOMER can place zero or many ORDERS.       
This provides flexibility where a CUSTOMER calls to register an interest, 
 or places an ORDER which is subsequenlty cancelled.   
C.2 An ORDER is always associated with one and only one CUSTOMER.   
 C.3 An ORDER always has one or more ORDER_ITEMS.    
C.4 A SUPPLIER can supply one or more BOOKS.   
 C.5 C.6 A BOOK can be in one or many BOOK_CATEGORIES.   
 C.6 A BOOK_CATEGORY can have zero or many BOOK_SUB_CATEGORIES.    
C.7 A BOOK_SUB_CATEGORY can belong to one and only one BOOK_CATEGORY.