Changing Child and Master Link Fields in Access 2003 Reports

Posted on 2009-04-15
Last Modified: 2013-11-28
I can not delete or update the Child & Master Link Fields in my subreport, as a result when I print the report there are a number of duplicates. To change the Child/Master Link fields I have went into the subreport's properties and tried to change the Master and Child Fields. But no matter what I put in it seems to go back to a "defualt value".

How can I update my subreport so there are no Master/Child Field links?
Question by:Ben_ocm
    LVL 74

    Accepted Solution


    "I can not delete or update the Child & Master Link Fields in my subreport"

    First Delete the subreport.
    Save the report.
    Run the compact/repair utility.
    Then re-insert the subreport.

    Now, are you saying that if you drop a subreport into the main report you cannot edit or delete the Child Master links?

      "when I print the report there are a number of duplicates"
    You need to be specific here.
    First, if you delete the links you WILL get a duplicates, (every subreport record will be listed for every Main Report record)

    I thought this is what you were trying to avoid?

    So I am confused?
    You say you wish to delete the Child Master Links (which would force the subreport to display duplicates)
    But at the same time you say that Duplicate values are part of the problem.
    Please clarify.

    I think a brief review is in order:
    A Main/Subreport is designed to display the One-to-Many relationship between two tables (Master/Child)
    Therefore, the subreport *Must* be linked to the Main Report on the common field.

    If this is not the case in your situation, then you need to explain the exact nature of the relationship between these two tables.
    Or better yet, post a simple example of this report that displays this issue.


    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    Where do we stand on this?

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

    734 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

    21 Experts available now in Live!

    Get 1:1 Help Now