Value Lists in a Relationship

[Tomo1]

This is pretty easy but my brain has just died! I have a database with for example car makes. I have a field called 'make' which is a value list of different makes (with me so far). I also have a field called 'model'. What I want is when I select ford I only want ford cars to appear in the field model. Likewise if I select Fiat I only want Fiats to appear!?!?!?

[LiveOak]

Create a realtionship to your "make" file and define a value list using this relationship. In your main file, the "left side" field for this relationship should be the one with the drop down to select "make". Your value list should select the "values from a field" option, then select a relationship.

-bd