Hi Utter Access

Hope you can help with this new project. Here is a short description of the situation:
The database shall record information on my company projects, i.e. a reference list. For each project we have clients, contractors, sub-contractors, consultants and the like. I like to record the specific combination of clients, contractors, sub-contractors, consultants for each project. Many of the companies involved are the same from project to project, but I need to record the specific combination per project.

I am sort of expecting that I need one (or maybe two) junction tables. This is where I am. Can I have this structure? I mean a junction table with 3 look-up values (fk)?

lktblCompany
pkCompany Autonumber
strCompanyName Text

lktblCompanyType
pkCompanyType Autonumber
strCompanyType Text

lktblProjects
pkProjectsID Autonumber
strProjectID Text

jttblCompanies
fkProjectID number
fkCompany number
fkCompanyType number

Thanks in advance

Sure. Why not?

Company type seems to be the role the company is playing in the
project rather than an attribute of the Company so I would say what
you have is correct.

Sounds good. Glad I got it right.