Parent Tables, Table Occorrences and flow of Information
I have a parent table PEOPLE, and several table occurrences: COMPLAINANTS, COMPLAINING WITNESSES, and RESPONDENTS (all in green below). I have placed joint tables between the occurrences and the CASES table.
My parent table contains all the information on individuals that are involved in cases. One individual can be listed on multiple cases in different ways (ex: as a Complainant, Complaining Witness or Respondent). I want to be able to go to the persons record (PEOPLE table) and see every case they are listed on. How can I do this?