Dear all,
I have a household form with records. It has some repeated records. Specifically, in within a visited households, I may have a child that I am targetting. According to the number of eligible children, I collect information about the households and I ma directed a repeated series of questions about children. In the end, I can only see two forms (households and Children). I CANNOT LINK THE TWO CODES (household information and childre's info) since there is no unique ID for the child which is similar to the one of the HH. How can I proceed. I am completely stack. Thanks
Welcome to the ODK forum, @ndalbe79! We're glad you're here. When you get a chance, please introduce yourself on this forum thread. I'd also encourage you to add a picture as your avatar because it helps build community!
The column for the repeat group in your main household information data table will have a unique value in it for each row/submission. The secondary table of children information will have a column that will have one of the unique values. If a single household has multiple repeats/children, there will be a separate row in your secondary table for each repeat/child.