Linking sub-items to records
Posted: January 13th, 2013, 2:52 pm
Dear CSPro Users,
I have a questionnaire which has two record types: household-level and person-level. The person level of course has multiple occurrences.
Within the person-level, I want to ask about another multiply occurring item: jobs. So I have multiple people within a household, and then a roster of multiple jobs for every person.
I have solved this by setting the questions on jobs as a multiply occurring sub-item within the person record. This seems to work fine for data entry.
But the problem is when it comes to exporting the data. I can export all the jobs into a "sub-item" database. The problem is that all jobs for a household end up being in the same database, without reference to which person they "belong" to (only the household identifier is stored with every job - but not the sequential person ID). So I end up with a database of all jobs performed by a household, but I loose the information on who did them.
Am I doing something wrong during export? Or is there a way of adding the sequential person ID to the sub-items so I can later link the two?
Thank you very much for any suggestions!
I have a questionnaire which has two record types: household-level and person-level. The person level of course has multiple occurrences.
Within the person-level, I want to ask about another multiply occurring item: jobs. So I have multiple people within a household, and then a roster of multiple jobs for every person.
I have solved this by setting the questions on jobs as a multiply occurring sub-item within the person record. This seems to work fine for data entry.
But the problem is when it comes to exporting the data. I can export all the jobs into a "sub-item" database. The problem is that all jobs for a household end up being in the same database, without reference to which person they "belong" to (only the household identifier is stored with every job - but not the sequential person ID). So I end up with a database of all jobs performed by a household, but I loose the information on who did them.
Am I doing something wrong during export? Or is there a way of adding the sequential person ID to the sub-items so I can later link the two?
Thank you very much for any suggestions!