https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/122808.aspxTue, 28 Apr 2020 17:16:20 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122808Froman0https://www.infopathdev.com:443/forums/thread/122808.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122808thanks, that does make sense!!https://www.infopathdev.com:443/forums/thread/122796.aspxMon, 27 Apr 2020 21:12:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122796Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122796.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122796So - if your dropdowns are in a repeating section, it is probably best to just query for all the data (as long as it doesn't impact load times for the form or cause other issues because the data load is huge). That's because if you requery the data source for the initial dropdown on each selection, you could end up with no data available if the user goes back to change an option in a prior row. Let's say your dropdowns are State and City. In row 1, the user selects WA for state. You query the city list for all cities where State = WA. User selects Seattle. In row 2, the user selects OR for state. You query the city list for all states where the State = OR. The user selects Portland. All is good so far! But now the user decides to change Seattle to Tacoma in Row 1. The State hasn't changed, so the query hasn't re-run. All the cities in the secondary list for cities are those where the State = OR. So when the user tries to change Seattle to Tacoma - all she sees is Oregon cities in the City dropdown. Make sense?https://www.infopathdev.com:443/forums/thread/122794.aspxMon, 27 Apr 2020 18:23:10 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122794Froman0https://www.infopathdev.com:443/forums/thread/122794.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122794I've been using a secondary data connection and filtering the results to get cascading dropdowns to work. I just stumbled across another method that uses query fields and rules to do the same thing. in what cases would one method be better than another? Thanks