Generating a specified number of individual records for each household record
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).