Another Conditional Value List

[Joel Saltzman]

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, 2007 by Guest

[Joel Saltzman]

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.