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/6247.aspxWed, 06 Oct 2004 18:16:43 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:6247Greg Collins0https://www.infopathdev.com:443/forums/thread/6247.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=6247Sounds like you have two drop-down lists in your view, and that when you select a value in the To_Currency drop-down list, you want to have your From_Currency drop-down list filtered to only show a specific list based on your previous selection. Is that accurate?<br /><br />If so, then you should just be able to add a filter to the From_Currency drop-down list to only show those values from the table whose To_ value matchs the selction in the node to which the To_Currency drop-down list is bound.<br /><br />Does that make sense?<br /><br />Greg Collins [InfoPath MVP]https://www.infopathdev.com:443/forums/thread/4474.aspxWed, 06 Oct 2004 09:22:06 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:4474victorlung0https://www.infopathdev.com:443/forums/thread/4474.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=4474Dear All,<br />How can i get data from the data source dynamically? can I pass any parameter to the data source, or I need to set filtering after get the data?<br />below is what I want to get:<br />a currency table with From_currency and To_currency, I want to show the "From Currency" depending on the "To_currency" I selected. <br /><br />table records:<br />SGD --&gt; HKD<br />CNY --&gt; HKD<br />YEN --&gt; SGD<br /><br />expected records in the drop-down list box when I selected "HKD" as the To_Currency:<br />SGD<br />CNY<br /><br />really thx for your help