I see what you are trying to do with the Tmp table, however when applying the part under Link I will get an extra field in the Link table, LinkDeparture. Basically what Im trying to achieve is that the link table should get the same output with different table setups.
The picture below shows the content of the Link Table, the right one is how it should be. The left one is with the other table setup.
I can get the Departure values in it, but not related to the ID numbers..
When I say:
It will of course just add 3 lines with the ID numbers, but not related to the DepartureDate..
(Ive attached the qvws if that is helpful for anyone)