Table Setup

any ideas on how I go about this:

I want to keep track of projects and people on projects but most of all money that people will get.

1 project my have many individuals on it
1 individual may be in many projects

so i guess i need 2 tables with a junction table linking them both up (is that right?)

thats the easy bit....

On each project there will be a deposit (e.g. Project A is left with deposit of £100). i need to work out firstly 20% of that deposit and then split that 20% between the individuals who are involved with the project. (e.g deposit for Project A is £100, so £20 gets split between the individulas who are assigned to that project).

So I want my database to firstly look to see how many indviduals are assigned to a project and then split the money accordingly.

firstly where do i record the individual split amounts and how do i work it out?

to make things a bit more complicated i also need another table with expense claims. this i guess is a One to Many relationship with the individual table. but what i want to do is be able to record the total balance between expenses claimed and the deposits splits mentioned earlier.

all this and it needs to be in a form that makes it easy to input the data.

i have the general layout in my head just cant work out how to go about linking the tables up and how to do the calculations

thanks in advance for any help

KTJ