I have a question regarding relations. I have already made a simple relation work but what confuses me the most
is how do you relate multiple items from a cell to a single category?
In my case I have built a job offers app and some offers have multiple locations and types of work, I was thinking there has to be an easier way to relate all of them without making a copy for each combination.
The things you want to relate must be the same.
Let’s say you have “Participatiewet, Requlier, Wsw” in “Vacature Mei 2021” Table
You also should have '“Participatiewet, Requlier, Wsw” in “Functiegroep” Table.
Use a Split Text column to split you comma delimited list into an array. Then you can can create your relation between your array of categories and the the single category.