I made repetition fields based on max number for each sport; entered the sport on first line, and made a script that copies from one field of existing text into appropriate field repetition for each record
From: FileMaker Pro Discussions [mailto:[email protected]] On Behalf Of Beverly Voth Sent: Tuesday, May 19, 2009 6:48 PM To: [email protected] Subject: Re: begin new topic in column Charlene, do share! :) -- Beverly Voth mailto:[email protected] tel:(606) 258-7399 -- On May 19, 2009, at 7:45 PM, "Flora, Charlene" <[email protected]> wrote: Thanks for reading. I found a solution that works great! From: FileMaker Pro Discussions [mailto:[email protected]] On Behalf Of Flora, Charlene Sent: Tuesday, May 19, 2009 5:09 PM To: [email protected] Subject: begin new topic in column Hello, I have a five column report, sorted by subsummary on field named sport; body contains name field. Each sport does not have the same number of athletes, therefore, when a name reaches at the footer, the next name of the same sport begins in next column. This particular list has been made in Excel where I manually begin a sport in the next column to avoid the spill-over. I want to find a method to start on the next column with a sport to avoid splitting the team up between columns. See below. Thanks in advance for your consideration in assisting me with this solution. Basketball Rowing Soccer Swimming Track 10 names 40 names 25 names 25 names 40 names Diving 5 names Golf Softball Volleyball 8 names 20 names 16 names Tennis Medical 12 names 8 names Charlene M. Flora, AAIT Administrative Assistant Division of Athletic Training/Sports Medicine Intercollegiate Athletics The University of Texas at Austin P. O. Box 7399 Austin, TX 78713-7399 512/658-2257 This message is for the designated recipient(s) only. It may contain privileged, proprietary, or otherwise confidential information. If you have received this message in error, please notify the sender immediately and delete the original. If this message contains Protected Health Information as defined by the HIPAA Privacy Rule, any dissemination, distribution or reproduction by a designated recipient to an entity not authorized by HIPAA Privacy Rule to have access to the information is strictly prohibited.
