ShadowIT
asked on
Populate Secondary Data Source based on Main Data Source
Hello Experts,
Here's my issue, I've created an Access 2003 query that I am using as a secondary data source. The query is grouping by buyer name and summing cumulative savings data. Access 2003 also contains my main tbl which is my Main Data Connection.
What I would like to do is reflect a specific buyer's summed saving when the buyer name field within the Main Data connection is matched to the secondary data source's buyer name field within the query. In the attached InforPathForm.jpg I would expect the buyer "Joe NoOne" to reflect $217.00 as per the attached AccessQuery.jpg with the "Buyer Cumulative Cost Reduction" field...please help! :)
p.s. Dhope has somethings that's close to what I am trying to accomplish but I haven't had any luck translating it to my specific situation
https://www.experts-exchange.com/questions/23948250/Query-a-secondary-data-connection.html?sfQueryTermInfo=1+data+infopath+rule+secondari+sourc
InfoPathForm.jpg
AccessQuery.jpg
Here's my issue, I've created an Access 2003 query that I am using as a secondary data source. The query is grouping by buyer name and summing cumulative savings data. Access 2003 also contains my main tbl which is my Main Data Connection.
What I would like to do is reflect a specific buyer's summed saving when the buyer name field within the Main Data connection is matched to the secondary data source's buyer name field within the query. In the attached InforPathForm.jpg I would expect the buyer "Joe NoOne" to reflect $217.00 as per the attached AccessQuery.jpg with the "Buyer Cumulative Cost Reduction" field...please help! :)
p.s. Dhope has somethings that's close to what I am trying to accomplish but I haven't had any luck translating it to my specific situation
https://www.experts-exchange.com/questions/23948250/Query-a-secondary-data-connection.html?sfQueryTermInfo=1+data+infopath+rule+secondari+sourc
InfoPathForm.jpg
AccessQuery.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Curious why a B rather than A, having giving an accurate answer and a diagram to walk through it.