Computed column

Hi all of you, I have confusion using Related function
I have table 1 in clude detail row include speaking part and related knowledge

then I create another table

but it return nothing.

Can anyone help?

Relations work by finding exact matches.
The way you have that setup, nothing with match.
Change it to match the “Speaking part” column in your first table, and it should work.

If I turn the match column to Speaking part. It return itselft. The value I expected is the Relation knowledge in detail table

Pls kindly help me to figure out

It’s working now.

Your next step depends on how you intend to use it. For example, if you want a list of the Related Knowledge values associated with each row, you can add a Joined List column that fetches those values via the relation column.

This might not be what you want, I’m just guessing.

Relations return linked ROWS. Not columns. You use relations to establish the link to related rows of data. Then you can use a Joined List, as @Darren_Murphy mentioned, to get a delimited list from one column in the related rows. Or you can use a Lookup column to get an array of values from one of the columns in the relation. Or, if your intention is to display the knowledge as a list, you can add a collection to you screen and set the relation as the source.

It all depends on what you are trying to do.