3 Replies Latest reply on Nov 30, 2011 4:39 PM by philmodjunk

    Table Occurences, related tables and pulling information

    kilbot

      Title

      Table Occurences, related tables and pulling information

      Post

      If you look at the relationships you can see that the CASES table is linked to the different EMP tables thru JT (join tables) and they work in pulling records from the EMPLOYEES table because they are all occurances.

      CASES-------JT TABLE---------EMP TABLE

      Now what if I wanted to see every case a employee was listed on no matter what JT the record was created in. Can I do thios since it all stems from the same table EMPLOYEES or am I unable to perform this. Basically I would like to see a record for every employee of every case they have been listed on.

       

      Thanks

      ScreenHunter_01_Nov._30_13.29.jpg