MS Access Database - Many to many relationship

  coolteentom 20:08 11 Oct 2007

Hi, not sure if anyone here will be able to help me out here, but I am currently studying databases, and am a bit stuck on a particular link between the following 2 tables:

- 'Jobs' (Primary key = JOBID)

- 'Employees' (Primary key = EMPLOYEEID)

Each job can have more than one employee involved, and each employee can have more than one job involved. I believe this is a many-to-many relationship and I understand that I need a linking table.

Does anyone know how to do this so that when I go onto the employee table, I am shown a list of jobs, and vice versa?

Regards, Tom

  coolteentom 22:12 11 Oct 2007

Just worked it out! No probs =D

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

Adobe shows still-in-development tools, including automatically colourising black-and-white photos

iPhone X news: Release date, price, new features & specs

Comment transformer un iPhone en borne Wi-Fi ?