Is this the case even if I would like to continue to upload excel spreadsheets that will only contain information for the Recruits table?
It seemed like keeping the tables separate would make that process easier. But perhaps not.
Thanks plog! If Recruits and ParticipantData have a 1 to 1 relationship (recruits will only have ONE participant data record) can I use one form?
It sounds like, however, with the Interaction Data Entry form I will need a form/subform. I'll check that out next.
Hello!
I have a question about repopulating fields in forms that I think involves a better understanding than I currently have about row source/columns.
Details
I have three tables.
The first table is Recruits, which contains recruit information:
-StudyID (creates 1 to 1 relationship with...