Relationship Help

Ya…you’re trying to create a relation in both tables using two different methods. It appears that you prefer to set which resources should be in the folder at the folder level using a choice component thereby creating an inline array. I imagine you’re splitting this column and relating back to the files themselves? This method is helpful (necessary?) if you want a file to belong to multiple folders.

However, this means that if you want to add a file to a folder from the file level, you’ll need to use what we call the Trebuchet method:

There are a couple of alternatives to this overall setup, but it would mean that files could only belong to one folder OR you’d need a helper table of sorts that would associate a file to a folder on each row of that table (thereby increasing your row quota exponentially).

2 Likes