3 Replies Latest reply on Apr 3, 2015 8:28 AM by philmodjunk

    Generating a specified number of individual records for each household record

    JamesRudge

      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