I have a field that links to another table (Initiatives) in my Budget table. In my interface, I'm trying to filter certain components by which ones have a certain initiative in that field. But, when I go to add an initiative to the filter, nothing shows up, so I can't actually filter by it.
Does anyone know why this might be happening? Trying to use anything other than "has any of" seems to make me have to type it (and still nothing shows up), and I'd rather it be more like a drop-down.
Thanks!