https://www.infopathdev.com:443/search/SearchResults.aspx?q=Sort+Drop+down+listSearch results for 'Sort Drop down list'en-USCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/p/39994/123422.aspx#123422Wed, 09 Sep 2020 15:58:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123422Hilary StoupaHi! So - you need to add a receive data connection to the Campaign Master List to your form. You will likely want to sort it by campaign name - that is one of the options on the screen where you select the list fields in the data connection wizard. On your dropdown field in your form, you'll add rules to set other field's values. When you select the value, it will be from your secondary Campaign Master List data connection, and you should see a "Filter data" button - click on that. You'll want to add a filter that the Campaign Name in the secondary data source is equal to the field in the main data source bound to the dropdown. It sounds so much harder than it is. :) Feel free to attach your form under the Options tab if you need a hand - you'll need to at least create the secondary data connection beforehand.