AnsweredAssumed Answered

conditional value list: two direction dependence

Question asked by BenOtto on Apr 21, 2014
Latest reply on Apr 23, 2014 by BenOtto

Title

conditional value list: two direction dependence

Post

     Hi

     I have a relation of category -> subcategory (eg.car brand -> model). Each category has it's own table to allow 1:n relations.

     What I do is define two name fields for each category and set the latter field (model) to an automatic value list that is populated on the flow in dependence on the upper-level item. E.g. when I enter Ford as a car brand my "model" field only displays a selection of ford models.

     Now suppose I have the following datasets:

     * Ford -> (Mustang; Ka; Focus; Fiesta)

     * BMW -> (Mini)

* Toyota -> () # Where Toyotas model list is still empty

     Can I set up a conditional value list for the car brand that only displays those car brands which have at least one model defined? (Eg. display Ford and BMW but NOT Toyota)

      

     To go a step further: Suppose I have a sub-subcategory "Build year" for each model in addition. Something like:

     * Ford -> (Mustang; Ka; Focus; Fiesta)

* BMW -> (Mini)

     * Toyota -> () # Where Toyotas model list is still empty

     and

     ** Mustang -> (1978, 1980)

     ** Ka -> (2004)

     ** Focus -> (2005; 2006)

     ** Fiesta -> (2001)

** Mini -> () # Where there is no build year defined for the Mini

      

     Can I pass the information about the missing build year record upwards to my conditional value list in my car brand field? (Reasoning: If I don't have a build year for the Mini I can't define it correctly and if I can't define my Mini then I don't need to display BMW because the Mini is the only model available in the list).

      

     To put it differently:

     I can create a conditional value list for my model field. When I select Ford as a brand, my model drop-down menu will only display ford models.

     But now I want to exclude all those models from the drop-down menu which are not related to any Build year dataset. So I need to combine two informations from an up-stream and a down-stream table at the same time.

      

     Note: I do know how to create a "normal" conditional value list where I will only display Ford models in the model field if I select Ford as a brand and so on. What I can't find out is if such a complex calculation as described above is possible.

      
     Thanks a lot
      
     Ben

Outcomes