[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 776
  • Last Modified:

Changing Child and Master Link Fields in Access 2003 Reports

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?
  • 2
1 Solution
Jeffrey CoachmanCommented:

"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.


Jeffrey CoachmanCommented:
Where do we stand on this?

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now