AnsweredAssumed Answered

Conditional drop-down list "not showing all related values from starting table"

Question asked by ChandraSrinivasan on Jan 22, 2014
Latest reply on Jan 24, 2014 by philmodjunk

Title

Conditional drop-down list "not showing all related values from starting table"

Post

     I have attempted to create conditional drop down list based on the suggestions from forums: by creating multiple table occurrences, self-join. There are 'DIAGNOSIS' under 'PHYLUM'. So I would like to restrict 'ITEMS' in value list based on 'CATEGORY'. Please note, the 'ITEMS' are rather lengthy texts (don't know if this has any bearing on my issue!). It all seems to be working fine, but for one problems. It appears that, when I select a 'CATEGORY', not all 'ITEMS' are being pulled under it.

     Here are some examples of each field:

     PHYLUM: 

Arrhythmia - Supraventricular tachycardia (SVT)

Arrhythmia - Ventricular

DIAGNOSIS

Arrhythmia, Supraventricular tachycardia (SVT), Atrioventricular reciprocating (Accessory connection-mediated tachycardia), Manifest accessory connection (WPW), Left free wall

Arrhythmia, Supraventricular tachycardia (SVT), Atrioventricular reciprocating (Accessory connection-mediated tachycardia), Manifest accessory connection (WPW), Left free wall, Posterior

Arrhythmia, Ventricular, Idioventricular

Arrhythmia, Ventricular, Prolonged QT (Long QT interval) ...............

What gets picked under related values seems pretty random. I have tried removing commas, cutting short characters etc. I don't get consistent results.

     I would really appreciate any help. Thanks.

      

      

      

Outcomes