Forum Discussion
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 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!
9 Replies
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.Hi jamiefisher
Please accept my solution if it helps you 🙂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
Thanks applied as you suggest below
However this gives me
and I only want to see courses pertaining to the employees position.
Hi jamiefisher
As per your requirement you can connect the following tables
If this helps please accept this as a solution!
Thanks
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 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.
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
