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.

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    Hi jamiefisher 
    Please accept my solution if it helps you ğŸ™‚

    • jamiefisher's avatar
      jamiefisher
      Helper I
      2 years ago

      Still no luck here is my three tables

      I can get a visual of staff and training they need for their post and a separate one of traning delivered but can merge the two into one visual.

       

      Really appreciate your help with this

       

       

      • Uzi2019's avatar
        Uzi2019
        Community Champion
        2 years ago

        I still dont understand what exactly you are looking. Do you want to display a table/matrix by getthing the values from 3 different tables??

        You can give the expected output in excel format what exactly you need. it woud be much easier to understand you requirement.

  • 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