We ran into the same problem and complaints at Clarkson a few years
ago.  We use a "home-grown" FoxPro database and we had always had a
separate "Investigator" table to add multiple investigators to a
proposal.  In order to track the distribution to departments, we added a
"percentage" field to the table records to allow the effort to be
divided between the investigators and their associated departments.  We
let the investigators determine the percentage for each investigator.

This has worked well for us.

Todd.

Todd C. Travis
Assistant Coordinator/Research Funds
312 Sci Ctr, Box 5630
Division of Research
Clarkson University
V: 315-268-6475, F: 315-268-6515
xxxxxx@clarkson.edu

Bill Campbell wrote:

> Francois and RESADMers--
>
> I faced the same problem a few years ago. Faculty were complaining that
> my annual report only listed the primary PI, not the co-PIs or other
> collaborators.  So I added a column in the ACCESS database I use to
> collect proposal and grants data and changed the format of the annual
> report to show all who are involved in generating the proposal.  (Check
> it out at
> <http://www.uwrf.edu/grants/annual%20reports/2003-04/ann%20rep%20home.htm>,
>
> click on Appendix D.)  Those complaints disappeared.
>
> But I'm expecting a new one anyday.  I haven't figured out a way to
> include those proposals in the summaries in this report and others, so
> that even though collaborators appear in the list of proposals submitted
> the dept and college totals only aggregate by primary PI.  If anyone
> knows a fix for that, please share it.
>
> Regards, Bill
>
> Bill Campbell
> Director, Grants & Research
> University of Wisconsin-River Falls
> 410 S. 3rd St.
> River Falls, WI 54022
> 715/425-3195
> FAX 715/425-0649
>
>
>
> ======================================================================
> Instructions on how to use the RESADM-L Mailing List, including
> subscription information and a web-searchable archive, are available
> via our web site at http://www.hrinet.org (click on "Listserv Lists")
> ======================================================================

======================================================================
 Instructions on how to use the RESADM-L Mailing List, including
 subscription information and a web-searchable archive, are available
 via our web site at http://www.hrinet.org (click on "Listserv Lists")
======================================================================