So, in my case I have Sale Points. and Options.
A Sale point can have multiple Options for this I have the Sheet Sale Point Options.
This is the “basic” configuration. Two sale points with the options.
In the Sale Pont Sheet I have this columns:
Selected Options is a rollup to the Options I already have selected.
Possible Options is a rollup to the Options, so I can make the add new option button invisible when no more options are left.
In the Option Sheet I have this relations to check wich Option is used in wich sale point. The Joined related Sale Point column is important for the choice component filter.
This is the visibility rule for the button
This is the filter option in the choice component
And this is how it works.
