How to manually make a relationship with multiple realtions?

So I thought this would be straight forward, and it might still be straight forward and just me missing something obvious.

I have a table with Q/A’s that explains different things within my app.
I have a different table where I manually group these Q/A’s together so they will can be used in relevant clusters around my app.

What I though I needed to do is take all the relevant ID’s from my Q\A table and comma-seperate them into a text column in my grouping table. Then have a relation column with multiple matches switched on and it should work.
However when I add more than one ID, the relationship field goes blank…

Does anyone know what I need to do to get multiple relations working?


Use a Split Text column to create an array from your list of ID’s, and then use that in your relation.

2 Likes

:face_with_open_eyes_and_hand_over_mouth: ohh my god, I knew it probably would be as easy as that, and for some reason my brain did not get there by itself. Thank you @Darren_Murphy

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.