Hello, Here is the scenario for the problem we are facing We have an InfoPath form that pulls data from a SharePoint 2007 list. If your form is browser based form and if it is infopath 2007, filtering is not supported on drop down lists. In this case you can bind drop downs to a secondary data source such as XML document with some dummy data and in form loading event and province value changed event, you can update this xml document to fill dropdowns appropriately. You can refer below page for the same. If the form is not browser based, you should get the filter option while binding city dropdownlist. Nice looking css fonts for mac. Thanks, Rahul Babar ASP.NET, C#, Sharepoint 2007/2010, Infopath 2007/2010 Developer.
Thanks Rahul,Lhan and Robert Actually one of the requirments for my form to be usable on SharePointis not to have any Coding in it so I'd rather not having any code in the Form Adding, I've tried filtering with Xpath as per Lhan's and the data connection filtering does not allow using the Xpath,I can't add the Xpath under Entries or Values. I also followed the toturial Video on this link And it does not tell me anything about filtering on a repeating table on a browser enabled form, the video on screencast talks about filtering on a non-repeating table that pulls data from SharPoint list Any ideas.? Thanks All for your Time Kal.