I have a table called Jobs.
Job No - Key
Site - Ref to Active Sites Slice
Site Name - Key
Active Sites Slice
Row Filter - [Active]=TRUE
So this works for when I add a new job, only the Active Sites will show in the dropdown list.
I have a slice called All Jobs based on Jobs table and a View called All Jobs grouped by Site.
I can’t work out how I can only show the Active Sites here. Help much appreciated.
Inactive Sites show as below (Union St)