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

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Infopath/Q_23948250.html?sfQueryTermInfo=1+data+infopath+rule+secondari+sourc
InfoPathForm.jpg
AccessQuery.jpg
ShadowITAsked:
Who is Participating?
 
DhopeConnect With a Mentor Commented:
Should be doable.
Set a dropdown that reads the main table with the names
When the value in the dropdown changes then a rule will set the value in a text field that picks the value from your secondary source, filtering to pick out the one where the names are the same.  See attached images

access.PNG
infopath.PNG
0
 
DhopeCommented:
Curious why a B rather than A, having giving an accurate answer and a diagram to walk through it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.