Frustrating secondary data source problem

[Bob P]

I've created a simple job costing form that uses a drop down list of
actives projects. I created a data connection to a SQL table, and it
grabs the data to populate the box just fine. The forms are the
submitted to a sharepoint site.

The problem I ran into was that was that a record was entered in the
SQL database with a wrong project number. After it was noticed, the
record was corrected, but the drop down list in Infopath still shows
the wrong information.

I've even created a new test form using a new data connector, and it
still shows the old data. Using the same data connector, I can insert
the information into Excel, and it shows the correct information.

If I add new records, the drop down box show them properly. It just
never seems to show the update.

What do I need to do to make sure updates to the database are
reflected in the drop downs?

 

[Bob P]

Problem solved (had duplicate fields in SQL, updated wrong one)