Table Occurences, related tables and pulling information
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.