I have a subform with data on household members linked to a main participant form. What I want to do is generate an ID number automatically for each household member, but to start again with 1 when the main participant ID number changes.
Any suggestions? Thanks!
So there is no way around it. I set it up like this to follow the format of the questionnaire (household data for each participant is part of the first section).
I have a main form (SMILI_entry) which has a subform (HH_data) at the bottom of the first page (Section 1) in a tabbed form with four pages. Ideally, all fields will be required before adding another record in the main form. However, when I set all fields to required and tab through the entry...