is it possible to link data within a table?

[jas]

Hi



I am new to using Microsoft Access, and have started a job which it predominantly using access.

I am in-charge of the data base, the table contains many fields for instance project code, organisation name, project,total budget fee etc.

Project code are unique and represents income stream and work of a consultant.

However i have been ask to link project codes, for when consultants are working on a project together, so when a monthly report is run the work will appear on both consultants reports and not just the ones.

is their a possible remedy for this?

[orange]

Can you show us your database structure (jpg of relationships window)?

Sounds like you may have

Consultant--->ConsultantWorksOnProject<-----Project

You may get some insight from this free data model