Hope this makes sense - any suggestions gratefully received.
We are doing a multi-level survey.
In the first form the user enters the name of the village and then the name of the head of household
In the second form the user enters the name of each individual
At the moment we are using a numerical household identifier entered in both Form A and Form B to link individuals to households.
i.e
A) Household Form
Village
Head of Household
Household ID
B) Village Form
Household ID
Individudal Name
Is there any way that when the user opens the Individual Form, that the Village and Head of Household lists can auto-populate based on what has already been entered.
i.e
They select a village
Based on that the system gives all the household names that have been entered against that village
Then they select that household and enter the individual against that house.
Hope that makes sense
Any suggestions gratefully accepted!
Michael