AnsweredAssumed Answered

HELP! CHECKBOXES VS. VALUE LISTS VS. PRINTED SUMMARIES

Question asked by WalterWhitmanMoore on Apr 11, 2015
Latest reply on Apr 11, 2015 by WalterWhitmanMoore

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.


Screen Shot 2015-04-11 at 10.34.22 AM.png

Outcomes