Re: Conditional Values in a Form

ErnestoM — Fri, 28 Oct 2011 12:06:31 GMT

I think what you're describing is a cascading dropdown. Check out this blog, perhaps it will help.

http://blogs.msdn.com/b/infopath/archive/2004/03/24/95529.aspx

Good luck.

Conditional Values in a Form

jmnatc — Fri, 28 Oct 2011 00:17:32 GMT

Disclaimer: I'm a brand new user of InfoPath, so apologies for a lack of proper terminology.

I have data in an Excel spreadsheet that shows how many days of training time an individual is authorized in a particular position based upon that individual's level of experience. Here is a simplified version of what I'm dealing with:

EXP LEVEL 1 EXP LEVEL 2

POSITION A 15 DAYS 6 DAYS

POSITION B 12 DAYS 3 DAYS

In Infopath, I am creating a form with drop down menus for POSITION and EXP Level. The form should automatically display a value for DAYS AUTHORIZED based upon the results from the table. For example, if the user selects POSITION A from one drop down menu, and EXP LEVEL 2 from the second drop down menu, the form should automatically display 6 DAYS in a third field.

This seems like it should be a relatively simple operation, but it has me completely flummoxed. Can anyone point me in the right direction?

General

Re: Conditional Values in a Form

Conditional Values in a Form