InfoPath Dev

I have a timesheet form I developed in infopath that links to a MOSS 2007 server.  I created a repeating table where an emplyee can enter the job they worked on and the time spent.  I created a drop down list box for the job numbers and tied it to a list I have in sharepoint.  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.  This works great if they work on a single job!  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:
Job No.                    Job Name
J100                          XYZ Corp
J201                          ABC Corp
J350                          ZZZ Corp
What happens is this:
Job No.                    Job Name
J100                          XYZ Corp
J201                          XYZ Corp
J350                          XYZ Corp

I found that the line below (J350  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.  If it is lower, it displayes the same job name as the line above.  In example 2, If I would have J350 first, then 201 and finally 100, all the job names would work fine.

Hi

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.

There is also an option to "Show only entries with unique display names", and this will cut down on the number of dupes you have in your pull down list.

Nate