This is my first time posting a query to the listserv! Maybe I'm just not thinking about this clearly, but I'm really stumped trying to create a Crystal report that will properly show Media Rendition information (rendition number, media type, etc.), Object Number, and Media-Related constituents (I'm just trying to get to the name of the photographer). Does anyone have a report they would be willing to share, or any suggestions on how to link tables properly? I'm sure somehow I don't have the tables linked correctly, or something like that. Shannon Perry Permanent Collection Database Administrator Smithsonian American Art Museum (202)633-8338 phone (202)633-8373 fax [log in to unmask]