display data in report from tables with same ID

[ronytimm]

Hi,

I have been struggeling with this for a while so really hope someone can
help me!
Would be much appreciated...

I have a table called offer_details with an Offer_ID as index. I have a
second table which has a similar offer_ID but which stores different data.

If I use a query to get the data for my report and link these two tables the
lines of the details are displayed multiple times because there is multiple
data in the second table with the same Offer_ID.

pls can someone help me with this...

Need more info, please let me know.

 

[Duane Hookom]

That's what occurs by default in reports. What do you want to happen?
Typically you use group header sections and/or subreports to get the display
format you want.

 

[Marshall Barton]

I have a table called offer_details with an Offer_ID as index. I have a
second table which has a similar offer_ID but which stores different data.

If I use a query to get the data for my report and link these two tables the
lines of the details are displayed multiple times because there is multiple
data in the second table with the same Offer_ID.

A one to many relationship can be easily be done in a report
by using Sorting and Grouping (View menu) in the report.
Group on a field (OfferID?) in the one side table
(offer_details) and put the one side fields in the group
header section. Then you can put the many side table
(second table) fields in the detail section.

If that is not feasible, an alternative would be to not join
the table in the one side report's record source query and
create a second report for the many side table. Then drag
and drop the second report from the database window onto the
main report's detail section.

 

[ronytimm]

Hi Duane, Hi Marshall,

thank you for your help. This has given me some options and I now know how
to solve this. Going to use a subreport and that seems to do the trick.
thnx a lot
grtz