InfoPath Dev

I am new to this form and hope to contribute as much as I learn.

But for now I have a question.

I am writing this in the hopes that someone here comes up with answer before
I figure this out.

Two data sources -
Main Connection is a table with fields A1, A2 and A3
Secondary Data Connection - S1,S2, S3

I created a repeating table to display A1, A2 and A3. I changed A1 to a drop down box and populated the drop down by binding it to the Secondary Data Connection. Therefore the drop down displays the data elements in S1.

What I am trying to accomplish is when a selection is made in the drop down A1, A2 and A3 get populated with the data from S2 and S3.

Everything I have tried populates A2 and A3 with just the first row of the Secondary Data Source and does not change based on the drop down selection. Right now A2 and A3 are just text boxes.

Can someone point me in the right direction?

Thanks

Hi,

please have a look under this link here, I guess it can help you
http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=4546

I found a solution that may help others

http://enterprise-solutions.swits.net/infopath2003/article.php?t=shrinking-dropdown-list-repeating-table&c=infopath2003