Could you help me with checkboxes and reports? I use checkboxes in one field; sometimes, two or more are checked. I want a report that will show me, for EACH checkbox that is checked, ALL of the records for which that box is checked. You with me so far? The problem is, when I set up a report to sort records based on each checked box, the report shows only one record per checked box. What am I doing wrong?
The tables I'm using are set forth in the picture below. In particular, I want to print a report showing, for each "Issue," all of the facts that related to that issue. The "Issues" field in the "Facts" table is where I have the checkboxes. There is a checkbox in that field for each "Issue" that appears in the related "Issues" table. Thanks in advance for helping the new guy.
Oh, and by the way, I was able to set up a nice portal report on the computer, which lets me see all of the facts relating to a given issue, but I really need something I can print out, without having to scroll.