one to many records in report, repeating records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a contact list report that will list the contact
information as well as listing previous call history. (Call info stored in
separate table with one to many relationship)

How do I get around all the data presenting itself mutiple times rather than
the main data once with the many call entries under it? (preferably the
simplest as possible as I know little about coding etc)

Cheers
 
triplespiral said:
I am trying to create a contact list report that will list the contact
information as well as listing previous call history. (Call info
stored in separate table with one to many relationship)

How do I get around all the data presenting itself mutiple times
rather than the main data once with the many call entries under it?
(preferably the simplest as possible as I know little about coding
etc)

Cheers
Click to expand...

You need to set up Group sections in your report using the Primary Key of the
contact to group on. You then place the controls for contact data in the group
section and controls dealing with call data in the detail section.
 
hurrah! that was painless! thank you!!!

Rick Brandt said:
You need to set up Group sections in your report using the Primary Key of the
contact to group on. You then place the controls for contact data in the group
section and controls dealing with call data in the detail section.
Click to expand...
 
eeek. spoke to soon regarding painless :)

what you suggested does work, however, now records that do not have any call
entries attached are not showing up in the report - is there a workaround??

Help, please? Thanks!!
 
scratch that - I figured it out. duh

(changing the one-to-many join properties in the query for anyone having the
same problem in the future)
 
Back
Top