I have an external list web part that I am currently using a choice filter on to filter by a certain status. The options are yes, no, or (empty). However, I would like to be able to add an additional option to filter where the person has the
previous status set to no, but has a value in a different field greater than 90.
I realize that the choice filter probably wouldn't do this, and that I could do this easily with separate list views, where I have some sort of web part that can change the list views on the fly. I would think I could use one of those list filters to do
this, but when I tried to do that for my original problem, I was unable to connect the filter to my external list. I could connect the list view filter to any internal list without an issue however.
Somebody commented on my old thread that I posted as cptInsane0 that I could just make an infopath view form that has buttons that do this. I have dabbled with infopath a little bit, but I wasn't able to get infopath to connect to my external list
either. I first had to connect to an internal one, and then for some reason I could add the external list as an alternate data source.
I can't be the first person who has had this issue. Could someone point me in the right direction?
View Complete Post