I still have som problem with the report functionality in this database. Please see the attached database. I have made a few adjustment on the database, but everything is working as I wanted.
The problem is that I want the main report to just print the person with a default value GroupDefault = True, and the subreport to print persons in the same group, but who don't have the default value GroupDefault = False.
For example, when I searching for GroupNumber = 3, I can see that the group contains 3 persons. PersonID = 3 is the groupdefault, everyone else is only a member. So when I press the print report, I want the main report to show PersonID = 3 because this person is the groupdefault. In the subreports I want to show all other members who is a member of the group only.
Example number 2: When I'm searching for GroupNumber = 3, but I'm looking in details for PersonID = 2 who is not the groupdefault. So when I print the report, main report still shows PersonID = 3, and subreports show all other menbers.
When I preview the reports (main and subreport) seperatly, the subreport show all persons which is within the same groupnumber. But when I use the subreport inside the main report, it's showing only one record.
I having a great problem solving this issue. I hope that this problem is solvable...
Thank you for all the help I can get