P
pattersong
Hi all,
I hope someone can help me. I have created a query form in Infopath 2003
using two SQL tables. I got the form 90% done. The last 10% is giving me
problems.
I have the Main data connection connected to a data source and a submitting
table. I attached a third data source as a secondary data connection. In
the data section of the query form, I have a drop down field where I can pick
the account I want. When I pick the account it should populate the
associated data in the query field. It is not doing this. It is only taking
the first line (row) of data.
Basically, what I am trying to do is gather data from two sources and
populate a third table. There is no relationship between the two data
sources. Help.
I hope someone can help me. I have created a query form in Infopath 2003
using two SQL tables. I got the form 90% done. The last 10% is giving me
problems.
I have the Main data connection connected to a data source and a submitting
table. I attached a third data source as a secondary data connection. In
the data section of the query form, I have a drop down field where I can pick
the account I want. When I pick the account it should populate the
associated data in the query field. It is not doing this. It is only taking
the first line (row) of data.
Basically, what I am trying to do is gather data from two sources and
populate a third table. There is no relationship between the two data
sources. Help.