MS Access Database - Many to many relationship

  coolteentom 20:08 11 Oct 07

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 07

Just worked it out! No probs =D

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

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

The updated 'Corel Painter inside Photoshop' plugin ParticleShop offers new brushes

Best running headphones | Best sport & fitness headphones: 4 brilliant pairs of wireless…