Hi Rodger, Here's one I developed way back (2006) when I took the CR training offered by Gallery Systems. Well worth the expenditure of time and money!! Although we no longer print out 4 x 6 in.-index cards (for which this report was designed), it's come in handily for other reports. Christine Droll Collections Database Administrator The Nelson-Atkins Museum of Art 4525 Oak Street Kansas City, MO 64111-1873 T: 816-751-1333 F: 816-751-0499 [log in to unmask] From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Kelly, Rodger S Sent: Tuesday, February 18, 2014 4:12 PM To: [log in to unmask] Subject: multiple constituent report or list view Dear TMS users, I created a Crystal report that shows basic tombstone info plus location and constituent, but I'm not sure how to account for multiple constituents (object related) and acquisition-related constituents. Does anyone have a Crystal Report or list view that does this? We are on TMS 2012. Thanks, Rodger Rodger Kelly Collections Manager National Music Museum The University of South Dakota 414 East Clark Street Vermillion, SD 57069 phone 605 677-5306 fax 605 677-6995 web https://urldefense.proofpoint.com/v1/url?u=http://www.nmmusd.org/&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=lb2dZVbRSynJuYhVX4tdHHxNku2otr9UdGxsV3xjEaQ%3D%0A&s=311f420cbdb346091ce77f5350da2182c647d892208be4b1385527bbc245a4e3<https://urldefense.proofpoint.com/v1/url?u=http://www.nmmusd.org&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=Xka5Xjt0G5PF3HEENQILxiAVNqOwGOlMX6wJVg2YFhU%3D%0A&s=76e595ba9805815c3b0a40c2e99144d738ed425c6cedff8d2a58853dd4f3c649> facebook https://urldefense.proofpoint.com/v1/url?u=https://www.facebook.com/NationalMusicMuseumUSA&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=lb2dZVbRSynJuYhVX4tdHHxNku2otr9UdGxsV3xjEaQ%3D%0A&s=a0485549825f504e9249f7b52f32f2c48a316d965a825209f96926c30be1881f<https://urldefense.proofpoint.com/v1/url?u=https://www.facebook.com/NationalMusicMuseumUSA&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=Xka5Xjt0G5PF3HEENQILxiAVNqOwGOlMX6wJVg2YFhU%3D%0A&s=8aec3ff1b90eda29c47fab1ad2e6bfa173e8b35f897b3ef445d6d71eeed48204> twitter https://urldefense.proofpoint.com/v1/url?u=https://twitter.com/NMMUSD&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=lb2dZVbRSynJuYhVX4tdHHxNku2otr9UdGxsV3xjEaQ%3D%0A&s=69dd30a90960091af9196f2a43abbd93f5491da97fa3a32d093df5d04f4b9bf3<https://urldefense.proofpoint.com/v1/url?u=https://twitter.com/NMMUSD&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=Xka5Xjt0G5PF3HEENQILxiAVNqOwGOlMX6wJVg2YFhU%3D%0A&s=439bb3c879d79b422a745ce37c4a5608a32004b1853b050ddce8705782b95b97> To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed.