I 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