I have a table with a list of Regions- used as a global reference. I have another table for Use Case Availability - a list of use cases and an Available column which lists the Regions in which this use case is available.
SO I want two selectors so that I can quickly lookup a Use Case and a Region and get true / false for ‘is this use case available in this region’?
selector: useCaseSelect ; selectable items: Use case availability.Use case
selector: regionSelect ; selectable items: Regions.Region
Instead of a selector I should have been using a lookup. Lookups read the whole row of a table, and you select by the ‘display column’ of that table. So I needed to change the Use Case column of Use Case Availability to be the display column. That way I can select by use case, and read across to the Available column.
Splitting the use cases into a separate list does work for the selector, but not for this lookup solution as the availability information is in a separate table.
Thanks for your help, always good to get a second pair of eyes! Leaving this solution up in case it helps anyone else.