Forum Discussion

jamiefisher's avatar
jamiefisher
Helper I
2 years ago

Table Links - Reltionships

I am struggling to get this to work so reaching our for some support. I have three tables one with staff names and post details, two with training course requirements for that post and three with det...
Tips and Tricks
Uzi2019's avatar
Uzi2019
Community Champion
2 years ago

Hi jamiefisher 
I think you should follow below relationship for your model. Dont create multiple relationship it causes confusion. 
only 2 relationship should be there. 


Please accept my solution and give kudos if It helps you.

jamiefisher's avatar
jamiefisher
Helper I
2 years ago

Thanks applied as you suggest below 

However this gives me 

and I only want to see courses pertaining to the employees position. 

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    Hi jamiefisher 
    As per your requirement you can connect the following tables


    If this helps please accept this as a solution!
    Thanks