You'll need different relationships to get a Hierarchical conditional value list to work.
Compare your relationships to those found in this thread:
Hierarchical Conditional Value lists: Conditional Value List Question
Thanks for the swift reply.
Ive tried what was in the reply and i still have no joy. How would a 3 tier conditional value list normally be set up ?
The first two work fine and the third even brings back partly right values but just isnt quite there.
There must be a key point im missing as ive seen many threads like this where the third dropdown just doesnt work. I still cant work it out though ?!
People often make the mistake of chaining together the table occurrences used in a linear series of relationships like you show in this thread:
But for your multi leveled series of condtional value lists to work, you can't use that series of relationships:
This is because all the fields that serve to filter the values for each conditional value list are defined in the same Table.
Using your table occurrences and match fields (which are also your drop down fields), they match up like this:
Data Continuous Sub Form::Building Element = lkUpComponent::Building Element ID (first conditional value list)
Data Continuous Sub Form::Sub Building Element = lkUpComponent 2::sub Building Element ID (2nd conditional value list)
If the notation that I am using here is unfamiliar and you are having trouble understanding it, see: Common Forum Relationship and Field Notations Explained
thank so much for this insight, ive cracked it and the drop downs work a treat, im over the moon !!!
Just another question while im on the subject. When a value is selected from the third value list table i want a number of other related fields from that table to appear on the layout. These are values which are on the same live as the item selcted if you like ?
Should be simple but im struggling?