I am trying to use a FM database to record the responses of study participants to a series of surveys. They will complete the studies on an iPad using FM Go. I have created a table for Subjects and separate tables for each survey. I want to create a relationship between the subject and each survey, and I've set up these relationships using the SubjectID as the primary key in the Subject table and foreign keys in each survey table.
Participants will first complete the subject table then go to another layout for the first survey. My problem is that I cannot figure out how to automatically relate the SubjectID to the new survey layout. I can do it using a pop-up menu, having the subject select the proper subject number, but I want this field to be automatically populated with the proper subject ID number. Can somebody please help a FM newbie?
Thanks!
