MS Access Database - Many to many relationship

  coolteentom 20:08 11 Oct 07
Locked

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.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac