InfoPath Dev

Dear All,
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?
below is what I want to get:
a currency table with From_currency and To_currency, I want to show the "From Currency" depending on the "To_currency" I selected.

table records:
SGD --> HKD
CNY --> HKD
YEN --> SGD

expected records in the drop-down list box when I selected "HKD" as the To_Currency:
SGD
CNY

really thx for your help

Sounds 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?

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.

Does that make sense?

Greg Collins [InfoPath MVP]