Hello all, I’m relatively new and am trying to understand table relations.
Base Table
I have a base table where I’ve populated the default “Name” column with a page link. In the base table this shows the page name as a clickable link (which is what I’m after). As an example I’m creating this table for each of the activities that the kids are involved with.
Related Table
I’m creating a related table for each organization related to the activity in the base table and have similarly setup the table by renaming the “Name” column to “Organization” and have populated it with a page link to each of the organizations.
Issue
When I try to add a new relation column in the base table, so that I can relate the organization to the activity, I’m seeing what appears to be the URL suffix instead of the linked page name. I’m not sure whether I’m doing something wrong with the column settings or if this is expected and my use case is an outlier… Any help would be appreciated.