InfoPath Dev

I'm new to InfoPath and I'm trying to add a Repeating table but I'm having
trouble with 2 columns. The first column (DropDown list) is populate from a
SQL table and the second column (text box) is a description of the item that
is selected from the Dropdown (also populate from a SQL table)
The problem is as soon as I add a second item on the 1st column both
description has the same value (from the last item I selected), if I selected
a third one then the description 'll change again. Is there any way that when
I select differents items and the descriptions stays with their corresponding
values?
Thanks for the help

Hi Alvin and welcome to the forum!

This can be done using the current() function as the default value for the second column. This has been discussed extensively in the forums and I'm sure if you do a search (upper right corner) for "current function" or "current()" you will find several posts to help you out. If you're still hitting a wall after doing this, feel free to let us know the error you're getting!

Thanks. By the time I read the post I found about the current() function. I'm still working with it. Very useful.

Now the issue I have is that I have a number control for the form and when I add elements to the repeating tables It was supposed to store the same control number for every element I add to the repeating table. Right now that field on my SQL database accept Null values and thats the value that is stored in my control number if I add 2 or more rows to the repeating table. Is there a way to do this?

Thanks for everything!