https://www.infopathdev.com:443/forums/44.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/12386.aspxWed, 14 Mar 2007 07:20:21 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:12386Patrick Halstead0https://www.infopathdev.com:443/forums/thread/12386.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=12386Hi Dean, <br />I recommend using our Database Accelerator which includes filtering so that you don't have to hardcode your query to return TOP N and so that you don't have to write code. The free dev edition of our Web service suite can be downloaded from http://www.qdabra.com/proddetail.asp?prod=QDBXL1. Send me e-mail and I'll send you a HowTo describing simple steps to use it.https://www.infopathdev.com:443/forums/thread/12164.aspxTue, 13 Mar 2007 19:36:52 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:12164dlgross0https://www.infopathdev.com:443/forums/thread/12164.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=12164I have a dropdown that is populated from a 2nd data connection, displaying a list of Offices. I would like get additional data for the selected office and put that data into read only fields on a form. How can I do this?<br />I know how to have a secondary data connection provide multiple columns and then have data from the same row as the selected item populate the fields on the form, but this did not perform very well and I'm trying to reduce the amount of data coming from my database.<br />Thanks<br />dean