https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/90924.aspxMon, 24 Jun 2013 19:58:29 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:90924jseeker0https://www.infopathdev.com:443/forums/thread/90924.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=90924<font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;text-align:justify;" class="MsoNormal"><font size="3"><font face="Calibri">Hi,</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;text-align:justify;" class="MsoNormal"><font size="3"><font face="Calibri">I am designing an InfoPath form and have pulled columns values and display using calculated value control from SharePoint list for an employee ID that is chosen.</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;text-align:justify;" class="MsoNormal"><font face="Calibri"><font size="3">The values pulled from SharePoint list are Job Title, Pay Grade etc., for a given employee ID. <span style="mso-spacerun:yes;">&nbsp;</span>This Job Title, Pay Grade values for an employee ID is stored and shown in InfoPath form as a calculated value control box.</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font face="Calibri"><font size="3">I want to design a drop down box with different options in the dropdown depending on Pay Grade and Job Title values. <span style="mso-spacerun:yes;">&nbsp;</span>Can someone walk me thru how I can get this done?</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">Thanks in advance.</font></font></p><font size="3" face="Times New Roman"> </font>