Table Links - Reltionships

[jamiefisher]

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 detail of training completed. I want to build a visual of all staff, what training is required and where there has been any completed.

My tables look like this but do not give the required results. Any help appreciated!

[jamiefisher]

Thanks - this realtionship gets me two standalone visuals which are fine but I cannot bring the two sets together as it doubles training records inaccurately - see below

[jamiefisher]

Hi this is my expected outcome

Staff			TNA	Training
Emp No	Name	Position	Course	Date	Course
138	j smith	Cleaner	a123	01/11/2022	MHT
138	j smith	Cleaner	b123
123	tom	Cleaner	a123	31/10/2023	MHT
123	tom	Cleaner	b123
124	dock	Cleaner	a123
124	dock	Cleaner	b123
125	harry	Catering Assistant	c123
126	joe	Catering Assistant	c123	05/01/2023	REHS

[Uzi2019]

I hope this solve your issue.

i think you need to display the  TNR courses based on position from staff table. and based on courses you get the compltetion date and courses from training table.

Thanks.

[Uzi2019]

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]

Thanks applied as you suggest below 

However this gives me 

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

[Uzi2019]

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

If this helps please accept this as a solution!
Thanks

[Uzi2019]

Hi @jamiefisher 
Please accept my solution if it helps you 🙂

[jamiefisher]

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]

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.