Populate Secondary Data Source based on Main Data Source

Posted on 2009-02-12
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
Question by:ShadowIT
    LVL 5

    Accepted Solution

    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

    LVL 5

    Expert Comment

    Curious why a B rather than A, having giving an accurate answer and a diagram to walk through it.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    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…
    ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now