DISPLAYING KEY INDEX FIELDS WITH MORE THAN ONE FIELD THAT CAN CONTAIN MULTIPLE VALUES

I've been scouring the forums for a solution to this problem and maybe
I'm looking in the wrong places but I can't find anything that will
even point me in the right direction. For example, I have a table that
contains 3 fields; FILE, ORDER DATE, and TRACKING #. A single FILE can
only have one ORDER DATE, but may have multiple TRACKING #s. Normally
on a report i would just group by FILE and the TRACKING #s will just
list beneath the FILE and ORDER DATE. Now I need to include PO #,
which really complicates things since it can contain multiple values.
When I try to group by FILE, I get every combination of TRACKING #s
and PO #s beneath it, so I am getting duplicates. How can I show two
independent lists grouped under each FILE and ORDER DATE?

This seems like the day for questions of 1 to many and 1 to many
relationships in queries and reports. If this describes your issue where the
"manys" aren't related directly to each other then you need to use subreports.
--
Duane Hookom
Microsoft Access MVP


"Rligouri" wrote:

I've been scouring the forums for a solution to this problem and maybe
I'm looking in the wrong places but I can't find anything that will
even point me in the right direction. For example, I have a table that
contains 3 fields; FILE, ORDER DATE, and TRACKING #. A single FILE can
only have one ORDER DATE, but may have multiple TRACKING #s. Normally
on a report i would just group by FILE and the TRACKING #s will just
list beneath the FILE and ORDER DATE. Now I need to include PO #,
which really complicates things since it can contain multiple values.
When I try to group by FILE, I get every combination of TRACKING #s
and PO #s beneath it, so I am getting duplicates. How can I show two
independent lists grouped under each FILE and ORDER DATE?