I cannot get the dropdown for country to filter by country. Here is my code for CEWP for sharepoint 2007. I have created 3 custom lists. One for Regions, this has the column title that holds the regions. Then I have a custom list for countries. this
has the column title and region. The title holds the names of the countries and the region column shows the region that the country is in. The third custom list is the form that pulls it all together. It has the region column set to lookup where it pulls up
the options to choose a region from the regions list. Then it has a another look up column for country. This is currently pulling through all the countries. I want it to pull up the countries within the region, not all of them. It looks like it is not accepting
the filter from SPServices. What am I doing wrong? I have put the CEWP with the script on both the allItems page and also the newforms page and neither one makes the countries filter.
// Set up the cascade from Region to State
CAMLQuery: "<Eq><FieldRef Name='Status'/><Value Type='Text'>Active</Value></Eq>"
I am wondering what is causing it not to work. It is either the way I have my custom list columns set up or it is the script. I followed your example and I could use come help on this asap. Thanks for your hard work on this.