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.