J
jman
I'm trying to set up a report that, although for an entirely different
purpose, is very similar to the 'Invoice' report in the Northwinds sample
database. I have it almost completely set up, but I cannot get the details
section to group as it is supposed to.
The information in my group header (which in form version is the information
contained within my main form) is linked to the information in my report
detail section (which would be the subform) by the 'PartID'. The 'PartID'
selected in the main section then gives you a table to enter related failure
data about that part. In form view, when you go to a new record you also get
a clean slate for the failure table. In report view however, the failure data
is not linking to the 'PartID' and is just displaying every failure entry for
all PartIDs. For example, if it is part 2 it is displaying failure
information for part 2, 3, 4, etc. all under part 2 and then displays that
same infomation for part 3, 4, and so on.
How can I stop it from doing this. I have done all that I know how to do
with the sorting/grouping options and I am at a loss for what to do.
purpose, is very similar to the 'Invoice' report in the Northwinds sample
database. I have it almost completely set up, but I cannot get the details
section to group as it is supposed to.
The information in my group header (which in form version is the information
contained within my main form) is linked to the information in my report
detail section (which would be the subform) by the 'PartID'. The 'PartID'
selected in the main section then gives you a table to enter related failure
data about that part. In form view, when you go to a new record you also get
a clean slate for the failure table. In report view however, the failure data
is not linking to the 'PartID' and is just displaying every failure entry for
all PartIDs. For example, if it is part 2 it is displaying failure
information for part 2, 3, 4, etc. all under part 2 and then displays that
same infomation for part 3, 4, and so on.
How can I stop it from doing this. I have done all that I know how to do
with the sorting/grouping options and I am at a loss for what to do.