I have a case called ‘Project’, which has an ‘Indicator’ child case. In the indicator details form (which you can access by first selecting a project and then selecting an already registered indicator), you can select which other indicators from the same project the currently selected indicator relates to.
I have a lookup table set up with the following statement:
instance(‘casedb’)/casedb/case[@case_type = ‘Indicator’][index/parent=current()/@case_id][@status = ‘open’]
This, unfortunately, results in a question with no choice values. If I remove the [index/parent=current()/@case_id], it return all open indicator cases, which is not what I want.
Thanks for your help on this!