Simple Conditional Value Lists Question

[jbrigham]

I am in need of a simple tutorial for creating Conditional Value Lists. I have found some articles and examples but nothing that clearly explains how to do it. Is anyone out there up to the challenge of creating the ultimate clear and concise explanation?

I would just like to have one database. I would like two fields, both of which provide value list choices. I would like the second field to have a list that changes based on the choice in the first field.

I realize this is fairly basic, but I just can't get my head around it and would appreciate any help you can offer.

[pkinnett]

This is exactly what I am after also - if you ever find out anything please post it up.

[Vaughan]

Part of the problem is that conditional value lists are *much* easier if you have TWO related files. The conditional value list is based on the reationship that links the files, and it simply returns the field values of the related records.

It can be done in a single file using self-joins, but conceptually (and technically) these are much more difficult to do.

Make a little practice file for yourself (say, with "cars -> models" or "animals -> breeds" or something simlar) and get the feel for it.