InfoPath Dev

I created a form and has a main SQL data connection. Now i've discovered that I need to add a new column in the database for another persons name. If I add this to the DB, does infopath support this, or will I have to completely redo the form?

New problem :) Now it is populating the dropdown correctly, but when I make a selection the rest of the boxes populate... I just want to choose a name and leave the rest blank.. Any ideas?

Right now i am just using one data connection. It is a sql connection with one table.. each column corresponds to each of the controls which are either text boxes or drop downs.. I just need to know how to put those people's names into one of the drop downs by automatically querying one of the columns in this table or another..

Well... Here is what I'm trying to do.. I have a form to request changes.. When filling out a new form... I'm trying to limit what the user can choose in the field submitted by. They should be able to select their name from a list. The drop down list needs to be filled with names from a SQL table when the form loads. I guess I will be using ...

I know how to link the form to a sql database.. Its just before when i was attempting to pre populate the values in the drop down so that the user had to select a name.. Infopath was acting weird. The values wouldn't show up at first, but once I hit submit, the values were populated in the drop down. I want them to show up before anything else ...

Hi, I'm new to infopath and my company and specifically my boss wants to start implementing infopath more and more as a forms tool to replace paper forms. I have been working with it to make basic forms, but I want to get more creative. I am trying to populate a dropdown list box with all the names in a column of a sql database before any ...