?
Solved

Populate Secondary Data Source based on Main Data Source

Posted on 2009-02-12
2
Medium Priority
?
663 Views
Last Modified: 2012-06-21
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
0
Comment
Question by:ShadowIT
  • 2
2 Comments
 
LVL 5

Accepted Solution

by:
Dhope earned 1500 total points
ID: 23631330
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
 
LVL 5

Expert Comment

by:Dhope
ID: 23702617
Curious why a B rather than A, having giving an accurate answer and a diagram to walk through it.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Before you can digitally sign infopath forms, you must have a digital certificate. Microsoft Certificate Services will need to be enabled on a Windows Server 2008 to facilitate the creation and verification of the digital certifciates on the web ser…
Moore’s Law has proven itself time and time again since it was first introduced. So what’s next? Will Moore’s law continue to remain relevant, or will new technology take over and bring us the next big advancement in computing?
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question