After lots of reading, I still can't figure out this:
i have 3 forms where users have already entered data - Form1 is Cars; Form2 is Houses; Form3 is Dogs. They all have a dropdown field called "participant #" where the user must select before entering data.
Form1 has a calculated field called "total cars"; Form2 has a calculated field called "total houses"; Form3 has a calculated field called "total dogs"
I would like to create a 4th form called "Individual totals" which displays the "total cars", "total houses", and "total dogs" based on a participant #.
How do I pass the data from Forms1, 2, and 3 to Form4?