https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/17329.aspxThu, 06 Jul 2006 15:42:58 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17329Kalyan Gaddam0https://www.infopathdev.com:443/forums/thread/17329.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=17329Hello,<br /><br />Did You try using Filters on the drop down box. Using Filters and rules You can show only those entries related to your selection.https://www.infopathdev.com:443/forums/thread/16826.aspxThu, 06 Jul 2006 12:52:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16826forzaitalia0https://www.infopathdev.com:443/forums/thread/16826.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16826Dear InfoPath Developers<br /><br />I've got a problem with InfoPath, which I'd like to describe to you:<br /><br />On one of our SQL servers contains a database, on which we store entries for changes on database systems (The columns are: Date, System, Database, DBA, Change-Description).<br />I exported these information in an InfoPath-File, using the option "Data Link to SQL server".<br />The export/import makes no problems, but I don't know how to teach my XML-File to sort the output by database systems without showing me some other entries.<br />To give you an example:<br />I just want to see the entries for the system "xyz880". I'd like to be able to choose this system in a dropdown list.<br />I can see all available systems in the dropdown list but when I choose xyz880 with a click it doesn't sort anything. I don't know which settings I have to make. (??)<br /><br />This all is necessarily because I want to use the same template for each system. It should just be a form to insert information on one of these systems and not to save anything.<br /><br />Can you tell me what I have to do?<br /><br />Thank you very much