How to control inline views when many-to-many relationships are involved

[_pete_]

I have 3 tables: Artworks, Tags, and a "Link Table". The Link Table exists because each Tag may have many artworks, and each artwork may have many tags. I created the relationships between these tables by setting a Tag Id and Artwork Id in the Link Table to ref, and then pointing each to their corresponding table. This generally works really well, except that I can't figure out how to make an Artworks detail page show tags as a deck view, while a Tag details page shows artworks as a gallery view. Here's what I mean:

Tag details looks right:

Artwork details does not look right:

I want it to look like this:

Which I can do by using a SELECT() function instead of REF_ROWS() in a virtual column in the Artworks table. But when I try to add a tag from the inline view using this method it takes me to the Tag form and I don't get a dropdown of possible values (like I do when I use REF_ROWS instead). In fact if I create a new row this way it's easy to create duplicate tags. Anyone know the right way for me to show tags as a deck view in my Artworks detail page. Grateful for the sage advice I always seem to receive here. 🙂