Forum Discussion

jamiefisher's avatar
jamiefisher
Icon for Helper I rankHelper I
2 years ago

Table Relationship Query

I have a draft visual to view a staff list, identify what training they are required to have based on their positon and display where that related training has taken place or not.   I can get two s...
Need Help
ray_aramburo's avatar
ray_aramburo
Icon for Super User rankSuper User
2 years ago

First, delete the relationship between Staff and TNR. 

Second, the relationship between Staff and Training should be One to Many. Not Many to Many. 

Fix that and see your outcome, if still you're not seeing what you are expecting, go to the options arrow in the Course Code field and select "Show Items With No Data".