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/41221.aspxFri, 01 May 2009 21:19:25 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:41221NateHarris0https://www.infopathdev.com:443/forums/thread/41221.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=41221<p>There is also an option to &quot;Show only entries with unique display names&quot;, and this will cut down on the number of dupes you have in your pull down list.</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>Nate</p>https://www.infopathdev.com:443/forums/thread/41006.aspxMon, 27 Apr 2009 10:52:52 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:41006madhuri0https://www.infopathdev.com:443/forums/thread/41006.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=41006<p>Hi</p> <p>It is the order that you add in the look up datasource of dropdown box.if you add J350 first then J201 then it will show J350 first ,next J201.</p>https://www.infopathdev.com:443/forums/thread/41001.aspxMon, 27 Apr 2009 10:16:58 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:41001ramakrishna0https://www.infopathdev.com:443/forums/thread/41001.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=41001<p>I have a timesheet form I developed in infopath that links to a MOSS 2007 server. &nbsp;I created a repeating table where an emplyee can enter the job they worked on and the time spent. &nbsp;I created a drop down list box for the job numbers and tied it to a list I have in sharepoint. &nbsp;I then created a column called job name and created a rule to automatically fill in the job name based on the job number selected. &nbsp;This works great if they work on a single job! &nbsp;When they have more than one line (because they worked on more than one job) the lookups do not work correctly. I want it to do this example:<br />Job No. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Job Name<br />J100 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XYZ Corp<br />J201 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ABC Corp<br />J350 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ZZZ Corp<br />What happens is this:<br />Job No. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Job Name<br />J100 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XYZ Corp<br />J201 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XYZ Corp<br />J350 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XYZ Corp<br /><br />I found that the line below (J350 &nbsp;line in the second ex) has to be higher in the dropdown list of job numbers than the line above in order for the job name to work correctly. &nbsp;If it is lower, it displayes the same job name as the line above. &nbsp;In example 2, If I would have J350 first, then 201 and finally 100, all the job names would work fine.</p>