Hope you had a nice Thanksgiving.
I have an xml file that includes hundreds of tools, the corresponding manufacturer number (serial number) and SAP number. This file feeds my infopath form that includes a repeating table with three drop-down columns (col1: Tools - col2: SN - col3: SAP). I I have been able to link the SN and SAP numbers to the tool, individually, but what I'm trying to do is to create the option, after selecting the correct tool name, to select the known SN from its drop-down, and have subsequent single option in drop-down for the SAP number...but also let the user select the SAP number, then be left with the single SN value in its drop-down.
Been struggling with it for a while and would appreciate any help.