First posting - Many- to - Many?

[Newbie-in-06]

Hi everyone, this is my first posting and I thank you in advance for
your help (I am very new to Access)

I need to create a database that shows employees, their workload, along
with the projects they are working on and the status of the projects.
There are multiple employees per project, and multiple projects per
employee (thus I believe I need to use a Junction table to link the
two.

Current set-up: Have 3 tables:
Employee/workload (employee is primary key)
Deals/status (Deal name is primary)
Junction (Deal name and Employee are both primary)

My end goal is to have 1 table list the employess and their workload,
with a drop down (expandable table) of their deals and the deal status.
If one employee updates the status od a deal, that deal's status should
update for all employees on said deal.

How can I accomplish this? Should I be trying to build out the
functionality in the Junction table, one of the other 2 tables, or do I
need to create a 4th table?

Any help is truly appreciated. The more detailed the better.

Thanks everyone

Newbie-in-06

 

[Jeff Boyce]

Don't try building this in the tables!

Access uses tables to store data, and forms to display (and edit) data.

I suspect you could use a main-form/subform construction to do what you
described.

Your main form would probably be the employee, while the subform would show
the project worked on information. You'd use your three tables behind the
scenes to do this.

Good luck!

Jeff Boyce
Microsoft Office/Access MVP