InfoPath Dev

I have a drop down list with a rule applied to autifll the value of a text box in a repeating table based of the selection in the list.  This works great for the first row in the repeating table.  As soon as I insert another row, then select another item from the drop-down list it autofills both text boxes in the repeating table. 

How can I set the drop down list to only autofill the last row in the repeating section.  I dont want the autofill rule to apply to every row in the repeating table.

There can be a couple of issues here:

1. You could have a non-repeating node in your repeating table which is being populated. In this case, it, of course, will always show the same value on every row.

2. If your drop-down is outside the table, and your rule populates a node in the table, then you will always get all rows populated with the same value. This is just how rules work on repeating tables. Unfortunately, there's no way to filter for a specific row in your rule. In this situation you will need to use code to set the value. 

Thanks for the response Greg.  I'm not experienced enough to use custom code for this.  The drop down is outside of the repeating table.  Would it be possible for me to email you my infopath form to take a look and point me in the right direction.  I have a feeling I'm trying to work around something there may be an easier solution for.  It's a pretty simple Purchase Order request form for the local Town that I work for.

 The purpose of the drop down menu's are for filling in the department code.  Rather than the users looking up the departmental codes, I wanted them to be able to select from drop down menu by name, and the textbox will autopopulate with the corresponding accounting departmental code. 

 I don't see a way to upload or attach the file here or I would.

 Thanks