Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

One to Many Report

Status
Not open for further replies.

SpeedStick

Technical User
May 24, 2007
37
US
I have developed an Action Item database. In which, I have main table named Action Item, which has a primary key field named ActionItemID. I have second table (Tbl_Assigned) for individuals who will be assigned these action items. Since there can be more than one individual to an action item, this table allows me to capture that one-to-many relationship. In this second table I have 2 fields (Assigned_Name) and ActionItemID named.

I am able to capture the one-to-many relationship in the second table. I am now trying show this table in a report. The report does show more than one individual for each action item but it creates a report for each number of individuals who are assigned to an action item. In essence if the there are 3 people, there will be three identical reports. How can I show only 1 report for each Action Item. Instead of having a report for each person who is assigned to action item.

 
You can place the ActionItem fields in a group header and the names in the detail section. As an alternative, you can create a main report based on only the Action Item table. Then create a subreport (possibly multi-column) of the tbl_Assigned records. Drop the subreport on the detail section of the main report and set the Link Master/Child to ActionItemID.

Duane
Hook'D on Access
MS Access MVP
 
Thank you for your response.

Yes, your solution is correct. I was able to use it. Thank you for taking your time and assisting me with my problem.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top