InfoPath Dev

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.

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 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?

This fixed the issue, thanks.

I am using two drop down list boxes with sources from a secondary data source. From the second dropdown box, I wish to populate 11 other fields. I am using rules to make this happen. I can enter up to 4 rules and it appears to work fine. When I put in the fifth rule nothing appears in the field associated with the rule. Is there a limit to the ...

The drop downs are now working. Thanks for your help. I then applied your article on Populating fields after selection. This again worked great! I hope to see more discussion on this forum as I like how it is broken down into the different areas based on whether you are using database, etc. Thanks again.

Greg, Here is my response to your previous answer on Office Online discussion. Downdown 1 is working fine. The dropdown list is correct. The question comes in what is the procedure to set up dropdown 2? Is is bound to the same field as Dropdown 1? When I do this they both reflect the same data. ''Greg Collins [MVP]'' wrote: > Since you ...

I have followed the suggestions by Greg Collins under his example Populating fields after selection. However, I get no data when selecting the default values. Are there some SQL database parameters that keeping this from happening? Form is creating inspection information which needs to also reference another table retrieving vendor name, ...