Re: Dynamic drop-downs with variables

Louie — Sun, 27 Nov 2011 15:32:46 GMT

Feel silly...was much easier than I was making it.

I filtered the data with the following conditions:

Tool (sec) = Tool (Main) and SAP (sec) = SAP (Main) OR Tool (sec) = Tool (Main) and SAP (Main) is blank

SAP

Tool (sec) = Tool (Main) and SN (sec) = SN (Main) OR Tool (sec) = Tool (Main) and SN (Main) is blank

Hope this can help.

Dynamic drop-downs with variables

Louie — Sat, 26 Nov 2011 14:24:21 GMT

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.

General

Re: Dynamic drop-downs with variables

Dynamic drop-downs with variables