Multiple Display Queries

cGREGgo

New member
Local time
Yesterday, 18:01
Joined
Oct 29, 2002
Messages
6
Ok, I have a database with 11,000 mixed drinks & their ingreidents. One table has the drinks listed, 11000 of them, and another table has the ingreidents, 1400 of those.

When I click on the plus sign on the drinks table, it opens a smaller window, like a sub database, and the fields there just show the id number for the ingreident, not the ingreident itself.

How can I get the queries to display the drinks in one column, with the names of the ingriedents in the 2nd column? I'm slowly working on a data access page. I understand the basic functions of Access, but this is way over my head. PLEASE HELP!
 
Blimey!!! 11,000 drinks!!! wouldn't mind working my way through that lot.

Sounds like you need to base the subForm on a query with the drink code as the link, or isn't it that straightforward?

Col
:cool:
 
well, not really, this subform has got me pulling out what's left of my hair!
 
I got it to display all the ingreidents, however, there is a new record for each one. Example...one of the drinks are called ACID, and there are 4 records now for that one drinks, each with a different ingriedient. That gave a crazy amount of records! I need all the ingredeents together....
 
That is the correct result. Drinks and ingredients have a many-to-many relationship. You need three tables. Drinks, Ingredients, and Recipe. Recipe contains a row for each ingredient of a drink. A Black Russion would have two rows in the recipe table and a White Russion would have three.
 

Users who are viewing this thread

Back
Top Bottom