My document type structure is

• artist
  • artwork

I want to store the artist name in each artwork so that when searching, if a user puts in an artist name, all related artworks are also found (since the artist name would be associated directly with the artwork).

I tried an ultimate picker. This allows me to select the parent node name from each artwork (which is the artist). However, only the node id is stored, not the name so its not shown in the search.

I also tried the ucomponents render macro data type, which allows me to directly output the parent page name in the artist field of artwork. However, the artist name is not stored when I publish the actual artwork page so again it doesn't show up in the search.

Any suggestions on how to get round this or a more obvious solution?

Thanks, Simon