SpeedStick
Technical User
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.
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.