Ghazelah, You can grab Constituent information about the Lender/Borrower by linking from the Loans table to any ConXrefs table via *Loans.PrimaryConXrefID*. For example, you can link from PrimaryConXrefID to ConXrefID in vConXrefs_Classic, and from there to Constituents via ConstituentID: Hope that helps! Best, Ian On Fri, Mar 10, 2017 at 9:06 AM, Ghazaleh Rabiei <[log in to unmask]> wrote: > Dear colleagues, > > In TMS, when creating outgoing loan agreements (and maybe some other > reports – I haven’t checked all the reports yet) the “Lender” information > is hard coded into the crystal report. > It was hard coded to input our last registrar’s name and her contact > information rather than pulling the relevant information from the > Constituents module. > As of Monday, our assistant registrar hard coded the new registrar’s > information into the crystal report so it’s up to date. However, that means > that all Outgoing loan agreement reports generated now (even past/closed > loans) will have the new registrar’s information. > > Is it possible to have the Lender’s information can be pulled from the > Constituent module so if we have to change information, we don’t have to go > into the crystal reports? Can anyone advise? > > Kind regards, > Ghazaleh > > *Ghazaleh Rabiei* > *Collections Manager* > > Email: [log in to unmask] > Phone: +1 416.646.4677 <(416)%20646-4677> (Ext.7722) > > *AGA KHAN MUSEUM* > > Connecting Cultures Through Art > > agakhanmuseum.org <http://www.agakhanmuseum.org/> > > > 77 Wynford Drive > > Toronto, Ontario, Canada M3C 1K1 > > > ------------------------------------------------------------ > --------------------- > > > NOW OPEN! > > *REBEL, JESTER, MYSTIC, POET:* > > *CONTEMPORARY PERSIANS* > > Encounter the works of artists who have chosen > self-expression over silence. > > > agakhanmuseum.org/contemporary-persians > <https://www.agakhanmuseum.org/contemporary-persians> > > *#ContemporaryPersians* > > > > DON’T MISS *SYRIA: A LIVING HISTORY * > > EXTENDED TO MARCH 26 > 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. > -- *Ian Eckert* Manager, Collection & Exhibition Technologies (CE-Tech) *The Museum of Modern Art* 11 West 53rd Street New York, NY 10019 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.