InfoPath Dev

We need to know how to use a field as a prompt to get the correct row of data returned from a sql table.  We have a view built with 10000 unique rows based on position data, we would like the manager to be able to enter a position number and have the data connection pull back the unique row of data attached to that position number.  We can't figure out how to get the prompt to work

 Qdabra's QueryDB web service was designed especially for this purpose and I would recommend checking it out if you might be doing this type of work from time to time:

http://www.youtube.com/watch?v=odt7QaPuVDo

If it's just for this one scenario and you are somewhat handy with code, you may also want to check out this post I made a while back:

http://www.infopathdev.com/forums/p/9467/33496.aspx#33496