I am using SP Designer 2007. In SP Designer, I have placed my custom list(ApplicationForm), which has some text fields and some dropdowns, lets say name(textbox) and country(dropdown).
In the (country) dropdown control, the values are coming from the hard coded values, which are created while creating the custom list.
In the SharePoint site there is another custom list called ListOfCountries which has list of values. I need this custom list values to be populated in the dropdown(country).
I heard it can be done using webservices. I do not know how.
How do I populate this? I heard there is SPwebservice from codeplex, but not sure where to start.
Any ideas or example please?