A problem with properly displaying data in the second module in the application.

[wertpol111]

Hello Appsheet community members! 

I have got the problem with my app for the hospital. Below is the description of it:

Here are my data (screenshot):

How the application works:
We scan the drug code and mark on the corresponding list where this drug is located (enum list). The function timestamp is also used to mark the time of this scan. Visible in the above screenshot.

Here is the description of data in the module 1:

But the problem is in the module 2, which is supposed to work in such a way that when we enter a scan of a drug's code, its entire route will be displayed to us along with the hours- where and at what time it was at that moment. 

Here is the description of data in the module 2:

Here is the formula in the column where is medicine referring to module 1 column- where is medicine (should also apply to time, but I do not know how to do it):

For now, it works in such a way that it simply displays the path of places, but to all drugs and not assigned to this particular one - which is what I mean here.

Thanks in advance for your help and advice 😉

[TeeSee1]

Try

SELECT( module 1[where is the medicine], [medicine scan] = [_THISROW].[medicine scan])

[wertpol111]

It doesn't work (;  And so thank you for your help, but if you had another idea(s) for this, I am open to suggestions. I will also try it myself.