Lookup

[SW]

I have two tables:
Table 1 contains recipes and is made up of ingredient numbers and other
fields.
Table 2 contains the ingredient numbers and the ingredient name.

I need to run a report that pulls the ingredient name from table 2 based on
the ingredient number that is listed in table 1.

Any advice is greatly appreciated.

 

[Rob Parker]

Create a query containing both your tables. Join the IngredientNumber
fields in each table. Drag the fields from each table that you require for
your report into the query grid; base your report on the query.

HTH,

Rob

 

[cyril007]

salut
Who are you

 

[SW]

Hi Rob,

This worked well, but only for the 1st ingredient number. Once I joined the
second ingredient number to the ingredient name, the query returned nothing.

Any ideas?

 

[Rob Parker]

I can think of a couple of things, but without knowing any details of you
tables and query I can't be sure of anything. Please post those details
(table fields and SQL of the query).

One possibility is that in Table 1 you have several ingredient fields (bad
database design; not normalised). If that's the case, you need to join each
ingredient field to a separate copy of Table 2 in the query (or, infinitely
better, redesign your tables).

HTH,

Rob