Its hard to explain without a visual so I included the beginnings of my db. I am working on the LAYOUT 4

I have a food table and the items are put into categories.

On the Form, I want to choose 1 item from my category drop down, then only show the food items in that category.... any suggestions or can someone show me how they would do this?

Edited December 3, 200718 yr by Guest

NM, I figured it out.

I related the categoryID from the meals table to the category table using a duoble occurence.

Here is the fixed one if anyone wants to look at it later.