Couple of things to clarify here:
- Nothing is locked up. Everything is working as intended.
- Relations don’t contain values. They just show the related records based on how you configured the relation. You can’t add, edit, or delete the contents of a relation. You can can only change the configuration of the relation and change the values that it is matching. To configure a relation, you pick a column in your table and link it to a matching column in another table. If there are matches, then you will see those related rows in you relation column.
- You can’t merge multiple relation columns together. Each relation serves the purpose you configured it to do.
- The relation in your last 2 rows is matching blank to blank in the related table. If you want them to go away, just delete the empty rows.
As far as solving your problem, you have a few options.
- Move all of your related content into one table and use one relation.
- Or, create separate relations, but add multiple lists/collections to the screen. One for each relation. Collections will only display if the relation is not empty.
- Or, change the action on your main list to a custom action, and add multiple IF branches in the action editor to go to different screens based on the chosen item in your main list.