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)?
Thanks in advance