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?