InfoPath Dev

I have drop down lists associated with a SQL database. That database is updated through another form. I then open the form that has the dropdowns in it. The data is not being retrieved. I check the parameters for the secondary database and the option to automatically retrieve the data on open is checked.

What could be causing this issue?

Try two things and then get back to me...

1. Go into the Enterprise Manager and verify that the SQL content has been updated in the database.

2. Create a new form which attaches to the database and see if you can get the new form to bring down the updated rows.

Greg Collins [InfoPath MVP]

Thanks for the reply. On Friday, I checked the database and the data records were there. Today I set up a new form and it retrieved the data.

I have found the error. I was doing a comparison on a parent table above the table I was querying. The data I had entered into the child table did not have corresponding data in the parent table.

Thanks for your help.

Glad to hear you got it fixed! Thanx for the update.

Greg Collins [InfoPath MVP]