December 20, 200718 yr Newbies I have a database called volunteer and a field named "interest" (which volunteers can show what they would be interested in doing) The interest field is set up as a check box field with a value list of: recovery packs fundraising ect ect.... What I want is a report that will show "Recovery" with the list of volunteers that have signed up to do recovery, then list packs and so on and so on. Recovery susie smith tommy jones Packs billy thomas Fundraising name name I tried to set this up using a layout with a leading summary and sorting on interest but the list is showing the interest every time with one person. Recovery susie smith Recovery Tommy jones How do I correct this? Thanks!
December 21, 200718 yr We need to know whether your Volunteers are a separate table. If so, create the report in the Volunteers table. You want the report to reside in the table where each record is a volunteer. Then your report can be created thus: * New Layout * Select columnar [next] * Report with grouped data [next] * Select your Interest field and the volunteer's name field [next] * Organize by Interest [next] * Select your theme and header/footer information [next] * Let FM create a script for you - it must be sorted by Interest. The Interest field should be standard edit field and NOT a checkbox or popup. Edited December 21, 200718 yr by Guest
December 22, 200718 yr Correction ... not where each record is a Volunteer - not like a Staff table - but rather a table of the volunteer activites.
December 22, 200718 yr IIUC, this is a many-to-many - each volunteer can sign up for multiple interests (hence the checkbox). However, the required report cannot be produced until the checkbox is replaced with a join table.
Create an account or sign in to comment