Good day all.
I want to build a form for about 3,000 farmers. Each farmer has a unique code from previous information gathered from them. Information such as state, local government area, city, gender, contact address, phone number have been documented for each of them.
I want to cascade these information on form building. However, I need to run through the already stored details of each farmer and also need to update other information.
How do I filter a farmer through the unique ID? I mean, if I type in a unique ID for a particular farmer, only other details of that farmer will come out in subsequent questions such as state, local government area, contact address, etc.