How to create a look up table?

Users
1

Hi I need help on how to create a simple look up table with two dependent values
field 1 Field 2
A B
A C
D E
D F

So, when I choose A in field 1, only the options B & C are available in drop down

2

Not sure if I understand this correctly but you can create two lookup tables.
Table1 shoul have only Field1 values (ie A, D ... as items).
This table should be used for one question to select option from Field1 only.

Have another table which should contain the table you've mentioned:
A --> B
A --> C
D --> E
D --> F

Based on the value selected for question of table1,you should filter out the value of options in table 2.

3

can I have your email id ?

4

how to create a table for terms ?
"you can create two lookup tables.
Table1 shoul have only Field1 values (ie A, D ... as items)."

5

Consider this example:
I have two tables :

image
image736×171 10 KB

first table is of 'vaccine type' and other is vaccine_type_configuration (As shown in image)
image
image1108×273 13.3 KB

Now in my form, I have a question where I am asking the type of vaccine, where I am asking which vaccine type beneficiary wants (as shown in image)

image
image1028×331 32 KB

Once the user has selected the type of vaccine, I am asking for the Dose Number for the selected type of dose (as shown in image)

image
image1037×349 32 KB

You can see the filter condition is 'vaccine_type = {{question-id of vaccine_type question}}'

Here is the resource for setting up lookup table if thats what is troubling you :
https://confluence.dimagi.com/display/commcarepublic/Lookup+Tables

6

Thanks for sharing this.