table design

[Emmanuelle]

Hi,

I am designing a database. I currently have a table for
sales, products, customers, special offers, promotion.
For sales analysis purposes I would need to know
-the product name (e.g. 250V metal halide lamp)
-the category {e.g. lighting)
-subcategory (e.g. lamps)
How do I go about doing it? I don't actually need to see
the information, I only need it if I want to know: e.g how
well a specific product has been selling, which category
sells best per company...
Should I create separate tables and then create forms and
subforms? But then I only need this information when I am
doing a sales analysis.

Thanks in advance

Emmanuelle

 

[kim]

I'm not sure exactly what you mean, but what about using
queries? If you are the one doing the analysis and are
behind the scenes, you can query your data in whichever
ways you like at anytime.

 

[Tim Ferguson]

For sales analysis purposes I would need to know
-the product name (e.g. 250V metal halide lamp)
-the category {e.g. lighting)
-subcategory (e.g. lamps)
How do I go about doing it? I

The sample Northwind database has a very similar structure: I suggest you
look at that and read through the documentation that comes with it.

B Wishes


Tim F