aussie_user
Registered User.
- Local time
- Today, 17:28
- Joined
- Aug 6, 2002
- Messages
- 32
HI,
I am building a database that records information surrounding grant monies given out by the department that I work for. Each grant is recorded as a project with an ID and description as well as the organization it was given to, the amount and various other data related to the grant. Some of the organizations that are given grant money hire consultants to do part of the work. Currently I have a field in my Projects Table that selects a Consultant from a dropdown box. There is a separate table for consultant information. In my final expenditure table I show how much money was actually paid to the consultant (as well as other major expense areas such as travel, advertising, printing etc).
The Records Management area of the Corporation that I work for is now requesting that we supply them with a list of all agreements for goods and services (over a certain value) that my department manages. 3 of the main details they require are Name, Description and Value. I understand this to mean that since the Grantee Organizations are contracting out some of the work to consultants, my department also manages those consultants ( in the past when there has been problems between the organizations and consultants my dept. has stepped in to oversee the consultants).
I would like to be able to eventually produce a report that shows
ProjID Org Descr. Amt
---------sub Contractor Descr Amt
ProjID Org Descr. Amt
---------sub Contractor Descr Amt
ProjID Org Descr. Amt
---------sub Contractor Descr Amt
Total Amt $999.999
With what I currently have I can pull the information for the for the main Organization, description and amount.
In order to eventually be able to supply the above style report can someone suggest where and how I should record the consultant information (which table). The amount finally paid to the consultants may not be the amount originally contracted for as in some past cases agreements were terminated when consultants did not live up to their agreed responsibilities. I will need to have a value of the agreement with the contractors (and also a description of what they are contracted to do) and was wondering if it should be in the Projects Table or the Amounts Table or if I should set up a separate Table.
If anyone has had experience trying to produce a similar report I would appreciate their advice on the best way to set things up.
Thanks.
I am building a database that records information surrounding grant monies given out by the department that I work for. Each grant is recorded as a project with an ID and description as well as the organization it was given to, the amount and various other data related to the grant. Some of the organizations that are given grant money hire consultants to do part of the work. Currently I have a field in my Projects Table that selects a Consultant from a dropdown box. There is a separate table for consultant information. In my final expenditure table I show how much money was actually paid to the consultant (as well as other major expense areas such as travel, advertising, printing etc).
The Records Management area of the Corporation that I work for is now requesting that we supply them with a list of all agreements for goods and services (over a certain value) that my department manages. 3 of the main details they require are Name, Description and Value. I understand this to mean that since the Grantee Organizations are contracting out some of the work to consultants, my department also manages those consultants ( in the past when there has been problems between the organizations and consultants my dept. has stepped in to oversee the consultants).
I would like to be able to eventually produce a report that shows
ProjID Org Descr. Amt
---------sub Contractor Descr Amt
ProjID Org Descr. Amt
---------sub Contractor Descr Amt
ProjID Org Descr. Amt
---------sub Contractor Descr Amt
Total Amt $999.999
With what I currently have I can pull the information for the for the main Organization, description and amount.
In order to eventually be able to supply the above style report can someone suggest where and how I should record the consultant information (which table). The amount finally paid to the consultants may not be the amount originally contracted for as in some past cases agreements were terminated when consultants did not live up to their agreed responsibilities. I will need to have a value of the agreement with the contractors (and also a description of what they are contracted to do) and was wondering if it should be in the Projects Table or the Amounts Table or if I should set up a separate Table.
If anyone has had experience trying to produce a similar report I would appreciate their advice on the best way to set things up.
Thanks.
