InfoPath Dev

I connected Infopath to a SQL database. I created a repeating table with the first field (PIN) containing the employees ID number. The employees ID number is suppose to populate the other fields such as first name, last name, etc. The problem is that when I enter an Employee ID with a greater number value it copies the first name, last name, and etc. from the previous fields. For example, if I type 28620 in the first row I will get the correct information. If in the repeating table I type 28619 I get the correct information but if I type 28621 it will copy first name, last name, etc from 28620's fields. How can I fix this problem? Another problem I have is the database has all the employee ID's with 5 digits. Some employees have four or less digits. In the database these ID's will have zeros in front. How can I automatically add zeros to the employee ID field (PIN) if the employee ID is not 5 digits long?

 So - my guess is that you have incorrect rules on the employee id field - that you aren't using filters to get the correct employee id row. Here's a little post on filtering data in InfoPath: http://www.bizsupportonline.net/infopath2007/autofill-repeating-table-data-sharepoint-list-row-inserted.htm

As to your second question, here is something that may help you with 0 padding: http://www.infopathdev.com/forums/p/20643/71474.aspx - scroll to Jimmy's post at the bottom of the thread.