NOT Using JOIN table for relationships.

I have a data model like this. Tools can have multiple Tags.

Tools have a Name and URL and a Tags EnumList  that works fine. See me editing a Tool's tags here. I can select multiple tags for each Tool.

Tools.png

Going the other way, I created a virtual field for Related Tools. Where, when viewing a Tag, you can see which Tools belong to that Tag. You can see below, Related Tools is an EnumList, with a Base ref of Ref of which is Tool and an expression of...

SELECT(Tools[ID], IN([_THISROW].[ID], Tools[Tags]) )

...and it almost works, but returns a list of the Tool's name (which is cool) but I'd prefer a listing I could view like cards, each one it's own thing... if you get what I mean.

Tags_Related_Tools.png

Any ideas?

Tom

 

 

 

 

0 23 563
23 REPLIES 23
Top Labels in this Space