Hi All,

I'm working in Access 2000. Sorry for the long post, I'm trying to be as clear as possible.

I've created junction tables to express M:M relationships for contractors and job task. Each contractor can performs many tasks and a task can involve many contractors. The general structure is:

tblContractors
ContID (pk)
Fname
Lname
Phone, etc

tblTasks
...