[Typo3] Getting value from different table by value from another table

[Jaroslaw Gilewski (YaGi)]

Hi,

I wonder if it is possible to achieve something like this by TS?

If I want to get a value from any field of the current table/record in 
TS we can use:

my_fk_key = TEXT
my_fk_key.field = my_fk_key

But my_fk_key is a value indicating some record in different table 
(foreign table).
Next what I want is to get the value of some filed from this foreign 
table. How can I do this?

Another possibility is that my_fk_key indicates more that one record 
(comma seperated ids). Is it possible to get the values of some choosen 
field from these records?

Yuor help will be very appreciated.

Regards

Jarek