Unsure how to link tables

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 Expenditu

Jan-Feb (monthly amount)
---------------------------------------------
Revenue Expenditu

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