Relationship Problem

[ann smith]

I have 4 tables.

1. Menu Table
2. Ingredient Table
3. Picture Table
4. Combination Table

Menu Table has Menu_ID and Menu Name (Primary key(PK) going to Menu_ID)
Ingredient Table has Ingredient_ID (PK) and Ingredient Name
Picture Table has Picture_ID (PK) and Picture

Combination has Menu_ID, Ingredient_ID and Picture_ID (no primary key in
this table)

Menu_ID Ingredient_ID Picture_ID
M0001 2
P0001
M0001 4
M0002 1
P0002
M0002 2
M0002 5

The problem I'm having is when I run the table wizard. The Menu_ID and
Picture_ID gives me what I want but not all the ingredient info is there. I
want to be able to create a relationship between the ingredient table and
picture table so that all the ingredients are shown when placed with a
specific picture. Any help is appreciated. Thanks.