Repeating Controls and Databases

[Michael Sainz]

Hey all,
I just don't know how to implement this so I will ask here. I want to do
a database lookup with one control, then depending on what was returned,
would return other information in the row.

For example, I would put a company name in the label, and it would submit
that to the database and return the address, telephone number, email, ect.
to some label controls down farther in the form. I would have thought I
would bind the first control as a query control and the rest as data, but
when I try and bind the rest as data, I get a popup saying that I have
chosen to bind a non-repeating control to a repeating field or group. My
issue is that there will only ever be one customer to a form.

Also, if there are some recommended web sites for Infopath, that would be
great!

Michael

 

[mag31]

Michael,

You need to bind the company to a repeating control. However, you then
select the repeating control's properties tab and turn off the insert option.
This means you can only have one company section in the form.

Best Regards,
Mark Grant
Cambridge Convergence Limited
www.cambridgeconvergence.com