N
Nodds
Hi,
I'm working on a database and while I think I know what I want to I
cant quiet get the thing to work.
My db will be used by project managers to record monthly spend and
resource/project assignments. There will be multiple projects and
both project managers and resources will be working on more than one
project.
The data that I currently have is:
Project Manager Details:
Manager Name
----------------------------
Project Details:
Project Name
Project Code - pk
Grouping
Approved Budget
Approved Capital expenditure
Approved Revenue Expenditure
--------------------------------------------
Resource Details:
Resource name - pk
Resource Category
Monthly days worked against each project
-----------------------------------------------------------
Capital Expenditure:
Jan-Feb (monthly amount)
---------------------------------------------
Revenue Expenditure:
Jan-Feb (monthly amount)
----------------------------------------------------------
At the moment I have a table for PM names, a table for resource name &
category, tables for monthly capex and monthly revex, a table for
project details and a table for monthly days for each resource against
a project.
What I want in an ideal world is for a form to display the following:
Project Manager Name
--------------------------------
A sub form for all the projects linked to the PM in it.
This will display project name, code, grouping, approved budget,
revenue & Capital
------------------------------------------------------------------------------
Another subform with all the resources linked to the particular
project.
this will display the resource name, category and days worked for each
month against that project.
----------------------------------------------------------------------------------------
A sub form to input monthly revenue expenditure against that project
------------------------------------------------------------------------------------------------
A subform to input monththly capital expendture against the project
--------------------------------------------------------------------------------------------
I've marked the unique records with pk, any help with this is much
appreciated.
Nodds
I'm working on a database and while I think I know what I want to I
cant quiet get the thing to work.
My db will be used by project managers to record monthly spend and
resource/project assignments. There will be multiple projects and
both project managers and resources will be working on more than one
project.
The data that I currently have is:
Project Manager Details:
Manager Name
----------------------------
Project Details:
Project Name
Project Code - pk
Grouping
Approved Budget
Approved Capital expenditure
Approved Revenue Expenditure
--------------------------------------------
Resource Details:
Resource name - pk
Resource Category
Monthly days worked against each project
-----------------------------------------------------------
Capital Expenditure:
Jan-Feb (monthly amount)
---------------------------------------------
Revenue Expenditure:
Jan-Feb (monthly amount)
----------------------------------------------------------
At the moment I have a table for PM names, a table for resource name &
category, tables for monthly capex and monthly revex, a table for
project details and a table for monthly days for each resource against
a project.
What I want in an ideal world is for a form to display the following:
Project Manager Name
--------------------------------
A sub form for all the projects linked to the PM in it.
This will display project name, code, grouping, approved budget,
revenue & Capital
------------------------------------------------------------------------------
Another subform with all the resources linked to the particular
project.
this will display the resource name, category and days worked for each
month against that project.
----------------------------------------------------------------------------------------
A sub form to input monthly revenue expenditure against that project
------------------------------------------------------------------------------------------------
A subform to input monththly capital expendture against the project
--------------------------------------------------------------------------------------------
I've marked the unique records with pk, any help with this is much
appreciated.
Nodds