Welcome to the community, @Nicky_Engert! :grinning_face_with_big_eyes: From your description, it sounds like you’re using multiple tables to track information about the same people. Is that correct? If so, I strongly suggest rethinking your design to only use a single table. To divide the different stages of the accreditation process, you would use multiple views that show different field combinations for those same contact records.
As an example, I teach online classes in an animation course, and have a base where I track everything about that course: students, course schedule, extra credit opportunities, etc. I have a single [Students] table where all student information is tracked. In addition to core info about each student (name, location, website profile link, etc.), I also have fields that help me with calculating grades for certain assignments, recording extra credit scores, tracking absences, etc. Altogether, I have 80 fields in that one table, but I don’t need to see them all at once. I’ve created views (17 total) to only show the necessary fields for a given activity. So when I’m grading their Week 4 assignments, I move to the “Grading: Week 4” view, which only shows the six fields I need at that time.
In the end, a single table ends up containing a lot of info, but it’s actually much easier to track by putting all necessary fields into that single table, and using views to manage what’s visible at a given time.
