Which table occurence is the basis for this layout? (What name appears in show records from in layout set up. )
what is the "starting from" table occurrence for both of these conditional value lists?
My last response was via iPhone while sitting in the ER with my wife. I didn't have ready access to this:
See the following instructional file on conditional value lists. The type of "chained" CVLs you describe are called "Hierarchical Conditional Value Lists" in this file. There are several different examples--all with detailed documentation of how they are set up and how they work.
Note that the relationship graphs for the version that is most like yours is quite different from what you have here. This difference is explained in the file.
Thanks for the replies Phil. Looking at this only now as I have spent the last two days sick in bed.