AnsweredAssumed Answered

Table Occurences, related tables and pulling information

Question asked by kilbot on Nov 30, 2011
Latest reply on Nov 30, 2011 by philmodjunk

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

Outcomes