AnsweredAssumed Answered

Generating a specified number of individual records for each household record

Question asked by JamesRudge on Apr 1, 2015
Latest reply on Apr 3, 2015 by philmodjunk

Title

Generating a specified number of individual records for each household record

Post

Hello,

I have a questionnaire which records household-level data along with individual-level data for each household member.

For each Household_ID I'd like to generate a specified number of Individual records in the individual data table.

For example, For Household ID 001, with 3 residents I'd like to generate 3 individual level records with Individual ID: 001-01, 001-02, 001-03 etc.

I'd also like the data entry form to automatically display a table with the corresponding number of rows/Individual IDs to enter individual level data.

(As you can seem I'm new to FMP(v13) but any pointers much appreciated).

Thanks!

James

Outcomes