I have a database that is keeping track of television series, episodes, and segments in that episode (usually 5 to 6 total). (These are in related tables respectively).
I have a filtered portal that shows the segments that are not yet completed. This list is filtered through a field on the Segments Table that is a boolean complete or not complete calculation.
I created a Value List ("Segment Name") that shows all the names of segments in the context of the related Episodes table. I then created a field on the Segments Table that is written ValueListItems ( Get ( FileName ) ; "Segment Names" ). However when I put this field on my filtered portal that shows the episodes with incomplete segments, the list gives me the names of all the segments and not just the ones that are incomplete (which is what I want).
I feel like I am missing something simple and got something like this working in the past, however any direction would be greatly appreciated.