Hi guys,
So I finally got my issues sorted and have my cascading dropdowns that filter available projects as pertaining to customers. One of my customers has the name format "Company & Associates" All the other company names work except for this one. I ran into the same issue when I was creating my dropdowns using the old javascript method that compared to a dataview. I suspect it has something to do with the escape character sequence, but I'm not sure.
The easy work around of course was to just spell out & --> as 'and' or to just drop the '& Associates' altogether, but it's worth a mention.
I plan on getting to work on figuring out a filter whereby utilizing an additional yes/no column representing a customers current active status only active customers appear in the parent dropdown but that's for a different day.
No files are attached