>Is there an easy way to create a source code log in ebase? If not, how >would I go about creating one. Essentially, what I'm looking for is a >table with source code names, descriptions and number of records that >related to it.
Most of the information you are looking for is in the file solicit_.103. Using FileMaker, log in with the master-level password, and you could export directly from that file. You'll want the fields Source Code, and Source Code Description certainly. The fields Response# is the number of payment records with that source code (at least those included in the relationship Gift, which means Dues and Contribution payments. Event\Purchase payments are not included. Action# is the number of Action records with that source code. There are no fields at present to accumulate Contact records, but you could add one using Action# as a guide. I'd export the records to an excel sheet so you could sort, format and print them to suit. Thanks for the question. I have never poked in that corner of ebase, and learned something along the way. Cheers, -- -- Dave Shaw H4 Consulting tel: 206-954-7526 fax: 206-625-1338 ------------------ Reminder to each recipient: To change your list account preferences, go to http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address you used to subscribe to the ebase support list:: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] --------------------------------------------------------------------- ebase - Relationship Management for Nonprofits, http://www.ebase.org ---------------------------------------------------------------------
