Querying tables with multi combo boxes

[Guest]

Hi all, I have a wee problem with my DB that I hope someone can help with, I
have a table called Engines this is linked to another table with 4 fields in
combo box style, this is because each type of engine can be used for a
different purpose

What I want to do is be able to run a query of some sort that would allow me
to add each individual type of engine together so that I can then generate a
report that would show the protential sales of each type.

In the relentionships view the engine table is replicated 3 times to form
the relationships for the combo boxes.

Many Thanks In Advance

 

[Arvin Meyer [MVP]]

Your design doesn't seem right. You don't need a column for each type.
Instead you need a single column for engine types. You also might want to
forget about combo boxes in tables. Tables are for storing data, not
entering or viewing it. (no matter how easy Microsoft makes it to do so)
Have a look at some of the reasons why:

http://www.mvps.org/access/lookupfields.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access