AnsweredAssumed Answered

Parent Tables, Table Occorrences and flow of Information

Question asked by kilbot on Oct 8, 2012
Latest reply on Aug 26, 2015 by BruceRobertson

Title

Parent Tables, Table Occorrences and flow of Information

Post

     Question:

     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?

      

Outcomes