If I understand correctly, a project can have many people working on it, and each person can work on many projects. If so, you need three tables: Projects, Contacts and a join table. The fee paid to a specific person for a specific project goes into the join table.
so i already have a join table which allows me to have the one to many relationship for contacts to projects... should i just add a final fee field in the join table?
thanks so much
Ahm... a join table allows you to have a many-to-many relationship between contacts and projects. But yes, any information that describes a specific join (e.g. person A worked on project X in the capacity of .... and was paid the sum of $... ) goes into the join table.