InfoPath Dev

I thought about that but i have 3 columns from this table that i'm grabbing data. if i filter it at the source, i won't have the data available in the form. The option there would be to create 3 data source connections and pull from each one that's sorted and filtered but how would I setup the form to pull from the correct datasource based on a ...

I've tried all the things that I have seen posted for filtering data into unique values and the one thing that I see is no metion of an external data source like from share point or from SQL. I'm pulling data from a SQL server into a drop down and need to get the unique values and sort them. This selection then drives the next drop down which ...