Hello all! I’m trying to link a couple of inputs across three tables and really struggling.
I have one table for Research Timetable, one table for Research studies, and one table for Panel members.
The Research Timetable auto-populates with the participant’s name and the name of the study (as well as some other information). I’ve set up a link between the Research timetable and the Studies table to auto-populate the participants into the studies table so we can see who will be participating in each study. I also want to link this to the Panel Members table to see what studies the panel members have been involved in.
Every time I try to link the one record to multiple tables it deletes the previous link. Help please!