Data Connectionshttps://www.infopathdev.com:443/forums/44.aspx enCommunityServer 2007 SP3 (Build: 31118.962)Forms with SQL in themhttps://www.infopathdev.com:443/forums/thread/117648.aspxWed, 15 Nov 2017 18:09:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:117648sclark550https://www.infopathdev.com:443/forums/thread/117648.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=117648I am new to InfoPath but not SQL. I have built a very basic Infopath form. It uses a table from SQL Server to load a drop-down list. The table contains 2 additional fields I would like display on the form but I do not know how. I have a sample below of what I am asking (below). Any ideas? Thanks in advance. Record Retention Schedule Record Series : Bill of Material (drop-down list (I chose Bill of Material and would like to get the description and retention period. All three are in the same record.) Description: Itemized listing of all components and sub-assemblies for a finished good including all notifications of changes to bills of materials. Retention Period ACY + 12 YRS