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 det...
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.
